Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
direct to certain cells using drop down list
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. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
direct to certain cells using drop down list
Courtesio99 wrote:
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. 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down list for multi cells | Excel Discussion (Misc queries) | |||
empty cells in the drop down list | Excel Discussion (Misc queries) | |||
Drop Down list that fills in other cells | Excel Worksheet Functions | |||
How to get the trendline values in excel 03 direct into cells ? | Charts and Charting in Excel | |||
drop down list that changes the data of 3 other cells | New Users to Excel |