Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
data validation, mouse action of select... then move right
I have a cell that uses a combobox selector to input data (data
validation). I'd like the active cell to move right after the selection is made. Is that possible? I can setup the enter key to advance this way or that, but I can't figure out how to setup a mouse action like this. Thank you. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
data validation, mouse action of select... then move right
Say you are entering data into cell B9 with some code. After the cell has
been filled, how about : Range("C9").Select or in the general case, if you are filling MyCell, then afterwards: MyCell.Offset(0,1).Select -- Gary''s Student - gsnu201001 "cate" wrote: I have a cell that uses a combobox selector to input data (data validation). I'd like the active cell to move right after the selection is made. Is that possible? I can setup the enter key to advance this way or that, but I can't figure out how to setup a mouse action like this. Thank you. . |
#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 |
Reply |
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) |