How to direct user to enter certain cells from drop down list?

C

courtesio99

How do i direct the user to enter certain cells after a certain data
from a drop down list is chosen?

I want to make it such that unless the respective option in the drop
down list is chosen, the user cannot enter in the corresponding cells.

Thank you.
 
B

bdcrisp

this might be easier to do using VBA, via textboxes versus cells. i
this an option for you? if so, i could show yo
 
R

RagDyer

If I understand your question, if your drop down was created using Data
Validation, then the user is NOT permitted any other enter except for what
is in your list.

However, for this validation to be in effect, you must make sure that:
1] There are NO blank rows in your list,
2] In the DataValidation dialog box, ErrorAlert tab, the Show Error Alert
box IS CHECKED.

Of course, the magic word here is "Entry".
The user cannot "enter" a value not on your list, but they sure as heck can
Copy and Paste anything they wish into the cell.
In fact, if they Paste Values, the cell even retains the Drop Down format,
while displaying the invalidated data.

If your users are wise enough to use this work around, then you will have to
go with code.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================




I totally dunno anything about VBA....
so can u kindly explain?
 
Top