direct to certain cells using 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.
 
Courtesio99 said:
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.
Click to expand...

I would define named ranges corresponding to the items in the dropdown
list. I would start with all cells on the worksheet locked and the
worksheet protected. On selecting an item from the dropdown I would
unlock the relevant named range and lock all others. Something like
this:

Sub ComboBox1_Change()
With ActiveSheet
.UnProtect
.Cells.Locked = True
.Range(.ComboBox1.Value).Locked = False
.Protect
End With
End Sub

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup
 
Back
Top