Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 37
Default Tracking border event

How could I track border drawing. Excel doesn't seem to generate this event.

--
Thanx & regards,
Asif
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,986
Default Tracking border event

Not the border per se, but for a chart there is a series change event. I am
trying to visualize how a border draw event would be used in a worksheet
range.

"Asif" wrote:

How could I track border drawing. Excel doesn't seem to generate this event.

--
Thanx & regards,
Asif

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 37
Default Tracking border event

I'm writing a row/col highlighter routine. The issue is that if a border is
drawn, Excel doesn't generate an event so I can't save the change as the
selection changes.
--
Thanx & regards,
Asif


"JLGWhiz" wrote:

Not the border per se, but for a chart there is a series change event. I am
trying to visualize how a border draw event would be used in a worksheet
range.

"Asif" wrote:

How could I track border drawing. Excel doesn't seem to generate this event.

--
Thanx & regards,
Asif

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,986
Default Tracking border event

There is a SelectionChange event for a worksheet. I haven't tried it so I am
not sure it would fire with a selection change by code. I know it fires with
a manual change. That could result in a lot of saving. It might be just as
efficient to put a save command in your code after the borders command has
executed.

"Asif" wrote:

I'm writing a row/col highlighter routine. The issue is that if a border is
drawn, Excel doesn't generate an event so I can't save the change as the
selection changes.
--
Thanx & regards,
Asif


"JLGWhiz" wrote:

Not the border per se, but for a chart there is a series change event. I am
trying to visualize how a border draw event would be used in a worksheet
range.

"Asif" wrote:

How could I track border drawing. Excel doesn't seem to generate this event.

--
Thanx & regards,
Asif

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
api - tracking LostFocus or Exit event of a combobox sebastienm Excel Programming 4 August 21st 07 10:45 PM
api - tracking LostFocus or Exit event of a combobox sebastienm Excel Programming 1 August 21st 07 07:24 PM
Tracking changes in Excel using an Event Macro Ukyankee Excel Programming 2 June 9th 06 02:21 PM
Change the border color used by Change Tracking Jim Stoaks Excel Discussion (Misc queries) 1 January 20th 06 09:32 PM
Changing the border of one cell s/n change the border of adjacent gjanssenmn Excel Discussion (Misc queries) 2 October 5th 05 08:35 PM


All times are GMT +1. The time now is 02:49 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"