Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down text won't change
OK, I used this simple routine to select an item in the "Plan" drop
down box. My problem is that this text will not go away once I select another item in the drop down. Using the Value property I was able to verify that the selected item did change, but the drop down box still says "Plan1". Any tips on what to do about this? Note, The drop down box text did change until I ran the routine listed below. Thanks Chris Sub test() ActiveSheet.DropDowns("Plan").Text = "Plan1" End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change the text colour in a drop down list? | Excel Discussion (Misc queries) | |||
How do I change the output value of a drop down box? | Excel Discussion (Misc queries) | |||
Getting drop down to change next cell | Excel Discussion (Misc queries) | |||
change info in other cells when i change a number in a drop list? | Excel Discussion (Misc queries) | |||
How do I change the text size in a drop down box | Excel Discussion (Misc queries) |