Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get the range index from combo box ??
Hi,
I need to extract the range index from active x combo box. For ex. when I select the first row in combo box, I will get the index 1 and assign this to a cell. I can do this easily with userform in worksheet. just right clicking and set the text fields. I try to look for under combo box properties, but don't find any. Should I write any script ?? Could anyone suggest me ?? Thanks. dennis |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get the range index from combo box ??
If you assign the boundcolumn property to 0, then the value of the control
will be the index. However, note that the index is zero based, so you would need to add 1 for your example. -- Regards, Tom Ogilvy "dennis logan" wrote: Hi, I need to extract the range index from active x combo box. For ex. when I select the first row in combo box, I will get the index 1 and assign this to a cell. I can do this easily with userform in worksheet. just right clicking and set the text fields. I try to look for under combo box properties, but don't find any. Should I write any script ?? Could anyone suggest me ?? Thanks. dennis |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup,Index,or Combo of something else | Excel Discussion (Misc queries) | |||
Unexpected #N/A error from INDEX-MATCH combo | Excel Worksheet Functions | |||
Can Index/Match pull lookup_value from a combo box? | Excel Discussion (Misc queries) | |||
Create/copy combo boxes in one range if condition is met in a different range | Excel Programming | |||
combo box, index formula problems | Excel Programming |