| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Go to a specific cell when selecting an entry in a validation list
I have a validation list in merged cells B4:E4 and would like a macro that
would take the user to specific cells when selecting each item of the validation list. For example, if the user chooses "Sales", the cursor is moved to cell A50, and if he chooses "Expenses", the cursor moves to cell C50. Chris |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Go to a specific cell when selecting an entry in a validation list
Make the row and column correspond to where your validation cell is located.
Add code to VBA sheet page (not module). go to tab on bottom of worksheet and right click (usuallly sheet1). then select view code. paste subroutine into pagge and make changes as needed. Sub worksheet_change(ByVal Target As Range) If (Target.Row = 3) And (Target.Column = 7) Then 'inset your code here. End If End Sub "Christine" wrote: I have a validation list in merged cells B4:E4 and would like a macro that would take the user to specific cells when selecting each item of the validation list. For example, if the user chooses "Sales", the cursor is moved to cell A50, and if he chooses "Expenses", the cursor moves to cell C50. Chris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Populate Date when specific entry is chosen from data validation | Excel Worksheet Functions | |||
| Selecting a cell entry based on cell validation selection | Excel Worksheet Functions | |||
| Search for a specific entry in a long data validation list | Excel Discussion (Misc queries) | |||
| Use Validation to force specific entry of first 3 characters in st | Excel Worksheet Functions | |||
| Change/cycle cell entry to next option from validation list (macro | Excel Programming | |||
Linear Mode
