| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieve value from .Shapes.AddFormControl(xlDropDown...
Hi,
Have created and filled a combobox using .ControlFormat.AddItem ..ControlFormat.Value seems to return just the index number of the selected item - how can the actual value from the combobox be picked up? Thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Retrieve value from .Shapes.AddFormControl(xlDropDown...
Got it:
MsgBox excelshapeobject.ControlFormat.List(excelshapeobje ct.ControlFormat.Value) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel document with shapes on it but the shapes do not print | Excel Worksheet Functions | |||
| Naming Auto Shapes and Creating new Shapes | Excel Discussion (Misc queries) | |||
| When drawing shapes in excel the shapes keep disappearing | Excel Discussion (Misc queries) | |||
| How can i get more 3D shapes for Auto shapes in excel? | Excel Discussion (Misc queries) | |||
| How can i get more 3D shapes for Auto shapes in excel? | Excel Discussion (Misc queries) | |||
Linear Mode
