Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
doubleclick to make cells move to another cell
i'm trying to program in excel and have one cell i dble click on go to
another cell. is this possible. There are around sixteen different cells to choose from. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
doubleclick to make cells move to another cell
Look at the BeforeDoubleClick event
Right click on the sheet tab and select view code. Something like this: Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Excel.Range, Cancel As Boolean) If not Intersect(Target,"Range("A1:A8","F1:F8")) is nothing then Target.offset(0,3.Select End if End Sub See Chip Pearson's page on events if you are not familiar http://www.cpearson.com/excel/events.htm -- Regards, Tom Ogilvy "rayjay" wrote in message ... i'm trying to program in excel and have one cell i dble click on go to another cell. is this possible. There are around sixteen different cells to choose from. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make cells not move in a worksheet | Excel Worksheet Functions | |||
How do I make the cursor move down 8 cells each time i press enter | Excel Worksheet Functions | |||
How can I make the cursor move down 8 cells each time I press ente | Setting up and Configuration of Excel | |||
How can I make the cursor move down 8 cells each time I press ente | Setting up and Configuration of Excel | |||
Query results make entire sheet's cells move | Excel Programming |