Two validation cells populated third validation

  • Thread starter Thread starter sowetoddid
  • Start date Start date
S

sowetoddid

In cell B1 I have four options in a drop down menu...

Rich
Lean
Flash
Other

In cell B2 I have two options in a drop down menu...

uncontrolled
controlled


Each combination (Rich&Uncontrolled, Lean&Uncontrolled
Rich&Controlled, etc.) except "other" should populate cells B13 to B2
with specific numbers. If they choose other, then B13 to B26 should b
left blank for user input.


Any ideas. It seems like an if-then problem, but I am not advanc
enough at VB to know how it can be done.


Many thanks
 
trying to learn this... Why are the cells not populated when I type Ric
into cell C5??

Thank you
 
Forgot to paste the code...

Sub Populate()
'
' Populate Macro
' Macro recorded 6/9/2004 by sowetoddid
'

'
If Range("C5").Cells = "Rich" Then
Range("C10").Cells = 1
Range("C11").Cells = 2
Range("C12").Cells = 3
End If


End Su
 
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

data lookup/validation syntax 2
Prevent duplicate entries within a range of cells from a drop-down 3
Validation list driving macros 1
Macro to retrieve values corresponding to the value selected in Dropdown box 4
Using Data>Validation cell formatting to drive OnEntry/Intersect m 1
Data Validation and drop-down list using IF, AND and what else? 8
using the if statement with data validation 2
Pick from drop-down list gives empty or erroneous result 6

Back
Top