Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboBox on worksheet-strange outcome
Hi
Using xl xp pro Have 2 combo boxes on wrksht CB1 is linked to cell B1 When I choose unit 20 from my list in the combo box unit 15 is placed in cell B1 Other times whatever I choose is exactly what is placed in cell B1 Any idea what is going on? --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboBox on worksheet-strange outcome
What combobox are you using?
From the Controltoolbox toolbar or the forms toolbar? The controltoolbox toolbar returns the value of the combobox in the linked cell. The forms toolbar returns the index into the list. If you right click on the combobox and see "assign macro", you've used the Forms version. Then you could use a helper cell with a formula like: =INDEX(A7:A21,B1) =index(inputrangeaddress,linkedcelladdress) "goss <" wrote: Hi Using xl xp pro Have 2 combo boxes on wrksht CB1 is linked to cell B1 When I choose unit 20 from my list in the combo box unit 15 is placed in cell B1 Other times whatever I choose is exactly what is placed in cell B1 Any idea what is going on? --- Message posted from http://www.ExcelForum.com/ -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Strange problem with a combobox and ListFillRange | Excel Discussion (Misc queries) | |||
Strange Line across Worksheet | Excel Discussion (Misc queries) | |||
Worksheet Combobox | Excel Discussion (Misc queries) | |||
Strange Prob with Worksheet name | Excel Discussion (Misc queries) | |||
strange worksheet.codenames in XL97 | Excel Programming |