Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
OLE combobox
Hi.
I have a little problem... I have a macro that creates a OLE combobox1, with 3 different selections, and puts it into a excel worksheet. Then when I have put the combobox into the worksheet I have an other macro which should get the text from the combobox and set it into av textbox which will be drawn in Visio. My problem is to get the text from the combobox. This code is the one I use to try to get the selected text in the combobox in the active worksheet. Dim shpObjComp As Visio.Shape shpObjComp.Text = Cells(row, column).Select But the combobox items doesn't get into the shpObjComp, the shpObjComp only writes out "true" Please help me! I dont know how to solve this! /Mikkan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
combobox changes value | Excel Discussion (Misc queries) | |||
How Do I Load A ComboBox RowSource From The Results Of Another ComboBox | Excel Programming | |||
Populating combobox from another combobox | Excel Programming | |||
ComboBox | Excel Programming |