PDA

View Full Version : Solved: Use named range with combobox



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.

lucas
02-21-2009, 02:18 PM
Moved to appropriate forum.


select the combobox and type Assessors in the rowsourse property.

lucas
02-21-2009, 02:19 PM
why would you name a combobox cmdAssessors? cmd usually means command button.

MLI
02-21-2009, 03:13 PM
Thanks Lucas