Qn: Load Data into UserForm1??

[Michael Vaughan]

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

 

[Tom Ogilvy]

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.

 

[Michael Vaughan]

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!!!!!!!