| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Two validation cells populated third validation
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 -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Two validation cells populated third validation
trying to learn this... Why are the cells not populated when I type Ric
into cell C5?? Thank you -- Message posted from http://www.ExcelForum.com |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Two validation cells populated third validation
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 -- Message posted from http://www.ExcelForum.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| custom data validation on cells with data validation values | Excel Worksheet Functions | |||
| data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
| Validation (Drop down list vs simple text length validation) | Excel Programming | |||
| Validation (Drop down list vs simple text length validation) | Excel Programming | |||
| Validation (Drop down list vs simple text length validation) | Excel Programming | |||
![sowetoddid[_29_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
