Let's say that the userform I created has a textbox called "TextBox1". In my worksheet1, there is a name "Jackson" in Cells(1,1). Using VBA, how do I add that "Jackson" into the "TextBox1"?
I want to do the same thing with ListBoxes. Eventually, I plan to expand and add a loop to insert a list of values into the listboxes and textboxes.
Please Login or Register to view this content.
Last edited by bananajelly; 05-14-2014 at 12:48 PM.
The code looks fine, it should put the value from Cells(1,1) on Sheet1 in TextBox1.
Are you having problems with it?
If posting code please use code tags, see here.
I get a "Run-time error '424': Object required."
This is for the command button. The debug states that the "IngLotNums.Show" is the problem. That's the name of my userform: IngLotNums. When I delete the Private Sub UserForm_Initialize, the UserForm shows up, so I think the problem lies in the code for the UserForm Initialize.Please Login or Register to view this content.
And yes, there is text in Cells(2,4).
Please Login or Register to view this content.
That's completely different code.
In the first code you set worksheet1 to refer to the worksheet 'Worksheet1' then use it to put the value in the textbox, in this code you set Form to refer to the worksheet 'magic', so that's what you should use in the rest of the code.
Try this.
Please Login or Register to view this content.
Okay. I see my mistake. I wrote magic.Cells instead of Form.Cells. It works now. Thanks! So you can customize UserForm from values within the spreadsheet. That's cool.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks