| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Issue with selection boxes and if statements
Hi Guys, can anyone help me with this i'm sure the solution ain't to bad. I'm trying to use a selection box and from that use an if formula t return a certain value depending on what's selected in the selectio box, the problem is i can't point the if statement to a cel as its selection and i don't know how to get it to look at the selection box Any ideas? Donni. :confused -- DDONN ----------------------------------------------------------------------- DDONNI's Profile: http://www.excelforum.com/member.php...fo&userid=1544 View this thread: http://www.excelforum.com/showthread.php?threadid=27484 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Issue with selection boxes and if statements
If the selection box is data validation, just refer to the cell of the DV.
If it is forms dropdown, right-click the object, select Format Control, and on the Control tab, set the cell link, that refer to that cell. -- HTH RP (remove nothere from the email address if mailing direct) "DDONNI" wrote in message ... Hi Guys, can anyone help me with this i'm sure the solution ain't too bad. I'm trying to use a selection box and from that use an if formula to return a certain value depending on what's selected in the selection box, the problem is i can't point the if statement to a cel as its a selection and i don't know how to get it to look at the selection box. Any ideas? Donni.  -- DDONNI ------------------------------------------------------------------------ DDONNI's Profile: http://www.excelforum.com/member.php...o&userid=15443 View this thread: http://www.excelforum.com/showthread...hreadid=274844 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Issue with selection boxes and if statements
Link the selection box to a cell using its properties. then your formula
can look at the cell. -- Regards, Tom Ogilvy "DDONNI" wrote in message ... Hi Guys, can anyone help me with this i'm sure the solution ain't too bad. I'm trying to use a selection box and from that use an if formula to return a certain value depending on what's selected in the selection box, the problem is i can't point the if statement to a cel as its a selection and i don't know how to get it to look at the selection box. Any ideas? Donni. -- DDONNI ------------------------------------------------------------------------ DDONNI's Profile: http://www.excelforum.com/member.php...o&userid=15443 View this thread: http://www.excelforum.com/showthread...hreadid=274844 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't check selection boxes | Excel Discussion (Misc queries) | |||
| Row Selection using Drop down/Combo boxes | Excel Discussion (Misc queries) | |||
| Help with If-Then Statements/Populating Data based upon selection | Excel Discussion (Misc queries) | |||
| Excel VBA - Range(Selection, Selection.End(xlDown)).Name issue. | Excel Programming | |||
| drop down boxes and if then statements | Excel Programming | |||
![DDONNI[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
