Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
We have a workbook with several sheets in it. I created a User form for Data
that is used several times through-out the workbook. I used the following code to get the User Form to load, but only a blank screen shows. Sub callUF() UserForm1.Show End Sub When I go to VBA Project I look under User form and it is there exactly as it was designed. What am I doing wrong? Is there anyway to get the User Form to Show up as the 1st sheet in the wookbook. The goal of this is so we only have to enter the data 1 time and the User form places the data in the correct Sheet and cell for us. There are about 50 Text Boxes in our user form, but they should all have same code, the only thing that will change is the Sheet and cell ID. Any help with code with be great. That way I can Cut/Paste it into each Text Box (Code) and change the sheet & Cell ID. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem with User form VBA | Excel Programming | |||
User Form Problem | Excel Discussion (Misc queries) | |||
User Form Problem | Excel Discussion (Misc queries) | |||
Help with a User Form problem please | Excel Programming | |||
problem with user form | Excel Programming |