Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
create combo box in excel
I have made the combo box. and I have also managed to list the details in
that box. When I select the values form it, I want the row number of the value that I have selected. When i mean the row number, I mean the rowmnumver from wher I have sourced the data. Basically, the first value that i select should display the value 1 next to the combo box. I am using this column number to generate in interactive chart Your help will be highly appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
create combo box in excel
Vinay,
You do this by formatting the control. Right click on the combo-box and select format control. In the cell link address box vavigate to the cell you want your output to appear in. When you run the combo-box the row number of the item you selected will be displayed in the cell you selected in the cell link box. Mike "Vinay" wrote: I have made the combo box. and I have also managed to list the details in that box. When I select the values form it, I want the row number of the value that I have selected. When i mean the row number, I mean the rowmnumver from wher I have sourced the data. Basically, the first value that i select should display the value 1 next to the combo box. I am using this column number to generate in interactive chart Your help will be highly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use Excel 2003 XML Map feature to create an SOAP XML file? | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
How do I create a combo drop down list in Excel? | Excel Worksheet Functions | |||
Why can't I insert a Combo Box in Excel? | Excel Discussion (Misc queries) | |||
create price list from excel sheet | Excel Discussion (Misc queries) |