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 |