Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I use a Combo Box to change values in a Cell.
here is what i am trying to accomplish:
I have a table of data: U.S 5000 France 3000 Italy 4000 Canada 6000 I want to have a Combo Box (the radio buttons would be nice) that has the four countries. When a country is selected it changes a reference cell. (i.e. U.S. is selected and it inserts 5000 in a cell that is used for further calculations) I know how to create a combo box such that a number changes in a reference cell but the number is just the ordnal number from my list (i.e. 1 thru 4). How to I link to my numbers? Sincerely, Jay R. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Default Cell Values at Change | Excel Worksheet Functions | |||
Getting Combo boxes to change options based on other Combo boxes. | New Users to Excel | |||
How do I lock cell value even if other values change | Excel Discussion (Misc queries) | |||
Can the scroll wheel be used to change cell values | Excel Discussion (Misc queries) | |||
Global change to cell values | Excel Discussion (Misc queries) |