http://support.microsoft.com/default.aspx?kbid=161514
XL97: How to Use a UserForm for Entering Data
http://support.microsoft.com/default.aspx?kbid=213749
XL2000: How to Use a UserForm for Entering Data
http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.
--
Regards,
Tom Ogilvy
"Michael Vaughan" wrote in message
...
Hello Everyone,
I have a UserForm1 with about 15 TextBoxes. A lot of input to be
inserted.
Now, let's say I wanted to update most of the info, and NOT all of it.
Right now, I am having to Re-type everything back into the textboxes. Is
there anyway to load the data from the cells from the worksheet into the
UserForm1 so that I don't have to re-type all the information. That would
save a lot of time. Any Help would be appreciated.
Thanks in advance.. mv