View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Janis Janis is offline
external usenet poster
 
Posts: 360
Default still get runtime error 424

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