Need help with a form.

[JONNEWBY]

So i have created a form that has 8 text boxes, and two buttons. "clear form" and "add to list".

so far my clear form button form works but i am stuck on the add to list button. it doesnt add it to my spreadsheet, my code must be wrong but i cannot find the problem!

have any tips for me?

thanks in advance,
-jonnewby

 

[wigi]

For instance, the code to write to cell A1 of the current sheet of a spreadsheet:

Range("A1").Value = Me.NameOfTheTextbox.Text

Obviously, change NameOfTheTextbox.

 

[JONNEWBY]

THANKS FOR YOUR RESPONSE WIGI,

there's a problem tho i have 4 worksheets in the same work book, how would i instruct it to go into a particular worksheet?

thanks for your help!!

 

[wigi]

Sheets("NameOfTheSheet").Range("A1").Value = Me.NameOfTheTextbox.Text

 

[JONNEWBY]

WIGI YOU HAVE SAVED ME A HUGE HEADACHE. THANKS A LOT!!!!!

-JONNEWBY