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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I use a Combo Box to change values in a Cell.
Havok,
You can sort your table by country than put a Vlookup function in the cell to get the number. Make sure your Combobox or buttons put the country in the appropriate cell. -- sb "Havok" wrote in message ... 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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I use a Combo Box to change values in a Cell.
Hmm maybe Im at a loss as to how to use the combobox to put the country
in the cell? I am by far an Excel expert. (Im actually a chemical engineer) Could you provide a little more step by step detail... ?? The help is very much appreciated. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I use a Combo Box to change values in a Cell.
Havok,
A lot depends on where the box is and where it is from: If it is on the sheet and from the Forms Control Right click the box and select Format Control Enter the cell address in the Cell Link box It it is on the sheet or on a form and from the Control Toolbox Right click the box and select Properties Enter the cell address in LinkedCell box you may want to enter it with the sheet name like Sheet1!A1 Now when you select from the box - the entry will go to the cell. Have your lookup formula reference this cell. -- sb "Havok" wrote in message ... Hmm maybe Im at a loss as to how to use the combobox to put the country in the cell? I am by far an Excel expert. (Im actually a chemical engineer) Could you provide a little more step by step detail... ?? The help is very much appreciated. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I use a Combo Box to change values in a Cell.
Actually I accomplished what I wanted to do using the INDEX function. Thanks for you help! -- Havok ------------------------------------------------------------------------ Havok's Profile: http://www.excelforum.com/member.php...fo&userid=2063 View this thread: http://www.excelforum.com/showthread...hreadid=160759 |
Reply |
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) |