views:

21

answers:

0

Hi,

Can anybody tell me how to create a Form in VBA that has two text boxes that when filled append a text file.

Lets say that the user types CHICKENS in textbox1 and EGGS in textbox2 then I want a sentence generated in the associated .txt file that says:

Don’t count your CHICKENS before your EGGS hatch.

Then if the user would decided the next line might say:

Don’t count your COWS before your MILK hatch.

That is assuming the user typed COWS and MILK

The txt file is to be appended and not over written.

I need this using VBA though I use to be able to do it in HTML, I can’t find any good sites on how to create such simple form (still novice with VBA express)

Can any one help or point in the right direction…