Try rightclicking on the dropdown and then look at the name box (to the left of
the formula bar).
"peekbo <" wrote:
I got the dropdown forms to default to the value I needed, however, on
any drop down that had a huge number in its name it would not execute.
For example:
Sheets("Inputs").DropDowns("Drop Down 12").ListIndex = 1
Worked fine, however:
Sheets("Inputs").DropDowns("Drop Down 23483").ListIndex = 1
Did not work.
Any idea. The way I figure out what each drop down name was, was
selected it and choosing assign macro to see what name it was
assigning. Something else I noticed. On the drop downs with large
numbers, it listed the whole file name before the drop down:
'Mission Profile Calculator - TEST - HIDE.xls'!DropDown2842_Change
However on the ones with small numbers, it only listed the dropdown
name:
DropDown12_Change
Any thoughts?
Brian
---
Message posted from http://www.ExcelForum.com/
--
Dave Peterson