| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Openform event
Is there a way to run code when an openform opens?
-- PK |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Openform event
Private Sub UserForm_Activate()
MsgBox ("Userform Activate") End Sub "Patrick Kirk" skrev: Is there a way to run code when an openform opens? -- PK |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Openform event
Excelent, no luck. When my userform opens, the listbox has no results,
meaning the code (below) is not running. ComboBox2.ColumnCount = 2 z = i - 2 ComboBox2.AddItem SstrName ComboBox2.List(z, 1) = SstrNumber Any suggestions? -- PK "excelent" wrote: Private Sub UserForm_Activate() MsgBox ("Userform Activate") End Sub "Patrick Kirk" skrev: Is there a way to run code when an openform opens? -- PK |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Openform event
Put ur code in the commandbutton on ur sheet that is running ur Form
some like this : Private Sub CommandButton1_Click() Userform1.Show Userform1.ComboBox2.ColumnCount = 2 z = i - 2 Userform1.ComboBox2.AddItem SstrName Userform1.ComboBox2.List(z, 1) = SstrNumber End Sub "Patrick Kirk" skrev: Excelent, no luck. When my userform opens, the listbox has no results, meaning the code (below) is not running. ComboBox2.ColumnCount = 2 z = i - 2 ComboBox2.AddItem SstrName ComboBox2.List(z, 1) = SstrNumber Any suggestions? -- PK "excelent" wrote: Private Sub UserForm_Activate() MsgBox ("Userform Activate") End Sub "Patrick Kirk" skrev: Is there a way to run code when an openform opens? -- PK |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Openform event
hmm maby u can use :
Userform1.ComboBox2.RowSource = "SstrName" "excelent" skrev: Put ur code in the commandbutton on ur sheet that is running ur Form some like this : Private Sub CommandButton1_Click() Userform1.Show Userform1.ComboBox2.ColumnCount = 2 z = i - 2 Userform1.ComboBox2.AddItem SstrName Userform1.ComboBox2.List(z, 1) = SstrNumber End Sub "Patrick Kirk" skrev: Excelent, no luck. When my userform opens, the listbox has no results, meaning the code (below) is not running. ComboBox2.ColumnCount = 2 z = i - 2 ComboBox2.AddItem SstrName ComboBox2.List(z, 1) = SstrNumber Any suggestions? -- PK "excelent" wrote: Private Sub UserForm_Activate() MsgBox ("Userform Activate") End Sub "Patrick Kirk" skrev: Is there a way to run code when an openform opens? -- PK |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Openform event
Excelent, thank you. It works!
-- PK "excelent" wrote: Put ur code in the commandbutton on ur sheet that is running ur Form some like this : Private Sub CommandButton1_Click() Userform1.Show Userform1.ComboBox2.ColumnCount = 2 z = i - 2 Userform1.ComboBox2.AddItem SstrName Userform1.ComboBox2.List(z, 1) = SstrNumber End Sub "Patrick Kirk" skrev: Excelent, no luck. When my userform opens, the listbox has no results, meaning the code (below) is not running. ComboBox2.ColumnCount = 2 z = i - 2 ComboBox2.AddItem SstrName ComboBox2.List(z, 1) = SstrNumber Any suggestions? -- PK "excelent" wrote: Private Sub UserForm_Activate() MsgBox ("Userform Activate") End Sub "Patrick Kirk" skrev: Is there a way to run code when an openform opens? -- PK |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Openform event
wellcome and merry christmas :-)
"Patrick Kirk" skrev: Excelent, thank you. It works! -- PK "excelent" wrote: Put ur code in the commandbutton on ur sheet that is running ur Form some like this : Private Sub CommandButton1_Click() Userform1.Show Userform1.ComboBox2.ColumnCount = 2 z = i - 2 Userform1.ComboBox2.AddItem SstrName Userform1.ComboBox2.List(z, 1) = SstrNumber End Sub "Patrick Kirk" skrev: Excelent, no luck. When my userform opens, the listbox has no results, meaning the code (below) is not running. ComboBox2.ColumnCount = 2 z = i - 2 ComboBox2.AddItem SstrName ComboBox2.List(z, 1) = SstrNumber Any suggestions? -- PK "excelent" wrote: Private Sub UserForm_Activate() MsgBox ("Userform Activate") End Sub "Patrick Kirk" skrev: Is there a way to run code when an openform opens? -- PK |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Open with Openform; Workbook not visible | Excel Programming | |||
| Click event on menu item is lost after first time firing of the event | Excel Programming | |||
| MsgBox in Enter event causes combobox not to run Change event | Excel Programming | |||
| How to trap delete row event and hide column event? | Excel Programming | |||
| OnTime event not firing in Workbook_Open event procedure | Excel Programming | |||
Hybrid Mode
