View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CRayF CRayF is offline
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..