View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Charlie Charlie is offline
external usenet poster
 
Posts: 703
Default refreshing a multipage

How? Just calling userform_initialize() doesn't refresh all the labels,
combos, & textboxes. They all get their data from 1 of several sheets. They
Get data from the worksheet wsMySheet, so when wsMySheet is changed to a
different sheet (by a control on the same form) I need to refresh
everything...

"Nigel" wrote:

re-initialize the form should do it

--

Regards,
Nigel




"Charlie" wrote in message
...
If you have a multipage on a userform that contains 40+ controls, is there
a
way to 'refresh' or 'reload' the page? ...maybe a loop that loops throug
all
the controls on the form and 'reloads' them?