Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I make cells not move in a worksheet VJ_xsell Excel Worksheet Functions 0 February 25th 10 06:27 PM
How do I make the cursor move down 8 cells each time i press enter Candys Kisses Excel Worksheet Functions 3 August 20th 07 11:08 PM
How can I make the cursor move down 8 cells each time I press ente Cadnys Kisses Setting up and Configuration of Excel 2 August 17th 07 08:08 PM
How can I make the cursor move down 8 cells each time I press ente Cadnys Kisses Setting up and Configuration of Excel 0 August 10th 07 08:50 PM
Query results make entire sheet's cells move chuckiej[_3_] Excel Programming 2 May 18th 04 03:14 PM


All times are GMT +1. The time now is 03:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"