View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_5_] Bob Phillips[_5_] is offline
external usenet poster
 
Posts: 620
Default Updating .tag in Userform Control in VBA

Chan,

No you will never change the default state of the tags in code, but by
putting it in the initialize event it will always be there whilst the form
is active. The other thing is to hide the form not unload it as suggested,
that way even if the form is not visible it is in memory and the tags will
persist for the time.

--

HTH

Bob Phillips

"Chan" wrote in message
...
Bob,

Great insights. Thanks.

By including the code in the form_initialize event, will
the tags actually update, or will they just update until
the form closes?

Chan