| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
data validation, mouse action of select... then move right
Rigt click on the sheet tab and click "view code".
Copy below code and paste it on the code window. A6 as the cell with validation. Change it to your cell address. ------------------------------------------------------- Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Me.Range("A6")) Is Nothing Then Target.Offset(0, 1).Select End If End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get a Data validation list to select another validation l | New Users to Excel | |||
| How to change action of double-click left mouse button? | Excel Discussion (Misc queries) | |||
| Cannot select single cell. Mouse move automatically creates range. | Excel Discussion (Misc queries) | |||
| Must move mouse before entering data? | Excel Discussion (Misc queries) | |||
| Computer freezes while using mouse to select group of data in Exce | Excel Discussion (Misc queries) | |||
![rumkus@hotmail.com[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
