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

  • Thread starter Thread starter courtesio99
  • Start date Start date
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.
 
this might be easier to do using VBA, via textboxes versus cells. i
this an option for you? if so, i could show yo
 
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?


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to creating
financial statements
 
Back
Top