adding data from a form

[pat67]

What i would like to do is update or add data from a form to a
specified table. The table is in another sheet that i am hiding. Is
this possible?

 

[Dave Peterson]

Yes.

But I'm not sure what you're really doing.

If you're using a worksheet that's designed to look like a form, you could look
at the way Debra Dalgleish did it:

http://contextures.com/xlForm02.html
and maybe:
http://contextures.com/xlForm03.html


If you meant that you created a userform (inside the VBE), Debra shares some
notes here:
http://contextures.com/xlUserForm01.html