| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.scripting.vbscript
|
|||
|
|||
Documentation on the "DropDown" object
Hi,
I'm using the "DropDown" object based on it's usage in "Excel 2002 VBA Programmers Reference" page 208. The text states that this is a hidden member of the Excel object model. So can anyone point me to some *secret* documentation on it? I need to know how to remove items from the DropDown box. The text shows how to add, and just a couple of other properties/methods. I'd like to know more... Thank you, Robert Stober |
|
#2
Posted to microsoft.public.excel.programming,microsoft.public.scripting.vbscript
|
|||
|
|||
|
Documentation on the "DropDown" object
Okay, I found almost everything I need in the object browser (after showing
hidden items) and by trial and error, but I still need to know how to cause one of the list items to be selected (showing in the box as soon as it's drawn) by default. I want the box to read "Select". Right now it's just blank, although clicking on the control shows the itms in the list. I want to make it more intuitive... Thank you, Robert Stober "Robert Stober" wrote in message ... Hi, I'm using the "DropDown" object based on it's usage in "Excel 2002 VBA Programmers Reference" page 208. The text states that this is a hidden member of the Excel object model. So can anyone point me to some *secret* documentation on it? I need to know how to remove items from the DropDown box. The text shows how to add, and just a couple of other properties/methods. I'd like to know more... Thank you, Robert Stober |
|
#3
Posted to microsoft.public.excel.programming,microsoft.public.scripting.vbscript
|
|||
|
|||
|
Documentation on the "DropDown" object
Activesheet.Dropdowns("Drop Down 1").Value = 1
if Select is the first item in the list. -- Regards, Tom Ogilvy Robert Stober wrote in message ... Okay, I found almost everything I need in the object browser (after showing hidden items) and by trial and error, but I still need to know how to cause one of the list items to be selected (showing in the box as soon as it's drawn) by default. I want the box to read "Select". Right now it's just blank, although clicking on the control shows the itms in the list. I want to make it more intuitive... Thank you, Robert Stober "Robert Stober" wrote in message ... Hi, I'm using the "DropDown" object based on it's usage in "Excel 2002 VBA Programmers Reference" page 208. The text states that this is a hidden member of the Excel object model. So can anyone point me to some *secret* documentation on it? I need to know how to remove items from the DropDown box. The text shows how to add, and just a couple of other properties/methods. I'd like to know more... Thank you, Robert Stober |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| why do i "sometimes" need to "edit chart object" before "source da | Charts and Charting in Excel | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| if "a" selected from dropdown menu then show "K" in other cell | Excel Worksheet Functions | |||
Linear Mode
