View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Load Data into UserForm1??

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