Qn: Load Data into UserForm1??
 

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

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

Load Data into UserForm1??
 

Hi Tom,

Yes Sir.. that did the trick. It was the Initialization command that did
it.

Private Sub UserForm_Initialize()

ComboBox1 = Cells(5, 4)
TextBoxP = Cells(3, 22)
TextBoxFP = Cells(4, 22)
End Sub

Thanks for all your help!!!!!!!


"Tom Ogilvy" wrote in message
...
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