Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 78
Default Check Box linked cell offset

Hi All,

How do I code excel to offset the cursor by 1 cell to the right from a Check
Box after it has been "ticked" by the existing macro?

--
Tracey @ BrisVegas
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,480
Default Check Box linked cell offset

Hi Tracey

maybe
Target.Offset(0 , 1).Activate

--
Regards
Roger Govier

"Tracey" wrote in message
...
Hi All,

How do I code excel to offset the cursor by 1 cell to the right from a
Check
Box after it has been "ticked" by the existing macro?

--
Tracey @ BrisVegas

__________ Information from ESET Smart Security, version of virus
signature database 4846 (20100208) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4846 (20100208) __________

The message was checked by ESET Smart Security.

http://www.eset.com



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
Check for 0, then offset down 310, left 4, Check for = 0 ryguy7272 Excel Programming 6 December 9th 09 04:01 PM
check box linked cell ranswert Excel Programming 5 March 26th 08 11:41 PM
OFFSET: Returns error when used to a linked file Arturo Excel Worksheet Functions 1 June 4th 07 11:48 PM
How to know the linked cell of a check box gm139[_2_] Excel Programming 3 February 5th 06 03:33 PM
OFFSET command and linked documents DawnS Excel Worksheet Functions 2 June 15th 05 09:31 AM


All times are GMT +1. The time now is 12:14 AM.

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

About Us

"It's about Microsoft Excel"