MLI
02-21-2009, 01:43 PM
Hi all.
I have a Named Range "Assessors" on sheet "Setup". On Form1 I have a combobox "CmdAssessors". What I would like to do is when selecting the drop button in the combobox, the names listed in the Named Range "Assessors" must showup in the dropdown list of the combobox. I don't know how to "call" the Named Range "Assessors" in the DropButtonClick event.
I have a Named Range "Assessors" on sheet "Setup". On Form1 I have a combobox "CmdAssessors". What I would like to do is when selecting the drop button in the combobox, the names listed in the Named Range "Assessors" must showup in the dropdown list of the combobox. I don't know how to "call" the Named Range "Assessors" in the DropButtonClick event.