Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Sorry, am I supposed to create a variable for the Listbox1.rowsource line?
I still get runtime error. It can't load the listbox. It is just column A, for easy testing I just used the first few rows but I need all last names in the listbox. So are you saying I must load the other two control combox'es the same way? What I did here works except for this list box but are you saying in order to run a procedure based on the choice I need to load them the same as the listbox I will change it but can you tell me why I get the 424 error? Thanks, Private Sub UserForm_Initialize() ComboBox1.AddItem "Print Single" ComboBox1.AddItem "Print Multiple" ComboBox1.AddItem "Exit" ComboBox3.AddItem Date 'ComboBox1.ListIndent = 1 ListBox1.RowSource = ThisWorkbook.Sheets("Patients").Range("A1:A12").Ad dress(external:=True) End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
runtime error '1004' application or object defined error | Excel Programming | |||
runtime error '1004' application or object defined error. Please help | Excel Programming | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
naming tab macro error runtime error 1004 | Excel Programming | |||
Syntax Error Runtime Error '424' Object Required | Excel Programming |