Just to make it easier to understand I just tried to load just the one combo
box with the
Private Sub UserForm_Initialize()

ComboBox2.RowSource =
ThisWorkbook.Sheets("Patients").Range("A1:A12").Ad dress(external:=True)
End Sub

I get the error message runtime 380 cannot load the rowsource?

"FSt1" wrote:

hi
no variable needed.
post the code your are using. for list box and combo box.

Regards
FSt1

"Janis" wrote:

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