Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 115
Default Update Values as soon as a Worksheet becomes active?

OK, Norman,
With your help, I learned more about the Private Sub Worksheet_Activate().

Got it fixed.

Program Summary is the main place racers are looked at as a whole.
When Im ready, I use the B1 Cell to kick off building this new Race
Worksheet.

The Race Worksheet is built using the RaceTemplate; a Header and set of 12
rows that make up a 1 race template where I can back changes and maintain
that the set of race rows look like. This set of rows are replicated as many
times as there are races from the Program Input File.

What I was trying to do is carry the balance forward from the previous race.
BUT I WAS GOING ABOUT IT WRONG.

Thanks to you asking for me about the snipet that called it, I got to
thinking why the heck would I not automatically add it during the building of
the Betting Sheet. Rather than when I got to it€¦ Kind of like DUH! Oh well€¦ I
got it fixed and learned more about the
Private Sub Worksheet_Activate() process..
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
Update one worksheet tab to automatically update all other tabs? shoechic1 Excel Worksheet Functions 1 May 24th 09 03:55 PM
Macro to update active workbook in one folder Mike @ GD Excel Worksheet Functions 8 January 15th 09 02:19 PM
Update Macro: Leave Colour As Before Once Cell is Not Active JB2010 Excel Discussion (Misc queries) 2 February 2nd 06 06:08 PM
Chart values do not update links to new worksheet DA Charts and Charting in Excel 0 November 28th 05 08:43 PM
update row numbers after different active cells in macros followi. LMIV Excel Discussion (Misc queries) 11 February 16th 05 12:44 AM


All times are GMT +1. The time now is 10:06 PM.

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"