R
rexmann
Hi
A little while ago I posted a question on how to get a multiple option
dropdown using the data validation option (unfortunately I can't seem to
find the thread).
The solution suggested worked great. The user selects an option in the
dropdown at the top of the spreadsheet which then altered the options
available in the rest of
spreadsheet.
Example
Select Option A at the top and only 1,2 and 3 are available in the dropdown.
Select Option B and only 4,5 and 6 are available.
It used the following code in the data validation
=OFFSET(ActivityStart,MATCH($B$3,ActivityColumn,0)-1,1,COUNTIF(ActivityColumn,$B$3),1)
However it has one problem, unlike a normal data validation the user can
type over
the options provided with their own selection. I want to lock it down with
just my
choices.
Is this possible? Any suggestions greatly appreciated
Rexmann (using excel 2007)
A little while ago I posted a question on how to get a multiple option
dropdown using the data validation option (unfortunately I can't seem to
find the thread).
The solution suggested worked great. The user selects an option in the
dropdown at the top of the spreadsheet which then altered the options
available in the rest of
spreadsheet.
Example
Select Option A at the top and only 1,2 and 3 are available in the dropdown.
Select Option B and only 4,5 and 6 are available.
It used the following code in the data validation
=OFFSET(ActivityStart,MATCH($B$3,ActivityColumn,0)-1,1,COUNTIF(ActivityColumn,$B$3),1)
However it has one problem, unlike a normal data validation the user can
type over
the options provided with their own selection. I want to lock it down with
just my
choices.
Is this possible? Any suggestions greatly appreciated
Rexmann (using excel 2007)