Issue with selection boxes and if statements

  • Thread starter Thread starter DDONNI
  • Start date Start date
D

DDONNI

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
 
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)
 
Link the selection box to a cell using its properties. then your formula
can look at the cell.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Perplexing IF statement 4
drop down boxes and if then statements 2
VB If statement Help 0
Select Case Statements 6
Autofill variable range 2
=(TEXT(RIGHT(A1,4),"####")&(TEXT(LEFT(A1,4),"####"))) 4
Combo Boxes 1
Using a combo or list box to select a statement 1

Back
Top