Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code Needed For a Macro
I have an excel sheet with the following values
A B 1 1a 1 1b 2 2a 2 2b 3 3a Now if i try to enter a value in an empty cell...i should get a dropdown containing the distinct values from the column -A....and when a value is selected..then when i try to enter a new value in the next cell i should get a dropdownlist containing the values in column B..but the one that are related to column A only ie if i select 1 then the next cell should have only 1a and 1b |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code Needed For a Macro
See http://www.contextures.com/xlDataVal03.html
and http://www.contextures.com/xlDataVal02.html -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "kalyan" wrote in message oups.com... I have an excel sheet with the following values A B 1 1a 1 1b 2 2a 2 2b 3 3a Now if i try to enter a value in an empty cell...i should get a dropdown containing the distinct values from the column -A....and when a value is selected..then when i try to enter a new value in the next cell i should get a dropdownlist containing the values in column B..but the one that are related to column A only ie if i select 1 then the next cell should have only 1a and 1b |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA code help needed | Excel Discussion (Misc queries) | |||
Batch file to start multiple excel files with auto_open() macro. Delay code needed | Excel Programming | |||
Code Needed | Excel Programming | |||
Better code needed | Excel Programming | |||
Code Fix Needed | Excel Programming |