Very helpful, and it works exactly as you say.

Getting slightly more technical now, I have set the combobox to have
default setting (so it doesnt appear blank when the form i
initialized). Also, one of the Textboxes has today's date inpu
automatically. However, when the form resets using your code, thes
things disappear. I've tried deleting the line that sets the control
to "", but that leaves everything (even the user typed entries)

Is there a simple way around this, or would it involve some seriou
(and probably waaaay over my head!) coding? I'm kind of learning VBA o
the fly, and I'm finding these examples VERY useful. Thanks to all wh
are trying to help a complete novice!


dude Wrote:
a combobox is a control - you should be able to read data
in to your array in same way.
If you create a test form as suggested. Add a combobox in
place of one of the textboxes (remember to add the button
on your form as last item (it's a control as well!)) Run
the form & add test data. It should place data from both
text & comboboxes into the worksheet.

hope helpful


--
madblok
-----------------------------------------------------------------------
madbloke's Profile: http://www.excelforum.com/member.php...fo&userid=1442
View this thread: http://www.excelforum.com/showthread.php?threadid=26092