Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
userforms
I'm trying to learn a little about userforms
I have a simple user form with one textbox This is the macro that open the form Sub form() frmUserform.Show End Sub There is one text box on the form called JobBox1 How do i get the form to open and put the value of cell A1 one in the text box. THANKS |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
userforms
hi
JobBoxox1.Value = Range("A1").Value regards FSt1 "Little Penny" wrote: I'm trying to learn a little about userforms I have a simple user form with one textbox This is the macro that open the form Sub form() frmUserform.Show End Sub There is one text box on the form called JobBox1 How do i get the form to open and put the value of cell A1 one in the text box. THANKS |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
userforms
Would it help to put that in the Initialize Event of the UserForm?
Right click the user form in design mode and click on the declarations box at the upper right of the code window. Then from the drop down menu, click initialize and put FSt1's code between the lines. Then when you run your show command, the text box will load with the range value displayed. "FSt1" wrote: hi JobBoxox1.Value = Range("A1").Value regards FSt1 "Little Penny" wrote: I'm trying to learn a little about userforms I have a simple user form with one textbox This is the macro that open the form Sub form() frmUserform.Show End Sub There is one text box on the form called JobBox1 How do i get the form to open and put the value of cell A1 one in the text box. THANKS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userforms | Excel Programming | |||
Userforms | Excel Programming | |||
Two Userforms | Excel Programming | |||
userforms | Excel Programming | |||
Userforms..... | Excel Programming |