refreshing a multipage

[Charlie]

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?

 

[Nigel]

re-initialize the form should do it

 

[Charlie]

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...

 

[Charlie]

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]

When you initialize your UserForm the controls presumably are set up? This
is the process I was referring to. If you want to change the references to
another sheet you need to re-assign them so you are initializing the
UserForm. You'll need to write the code to re-assign each control. Try to
make it as general purpose as possible so it can be re-used for other
sheets.


--

Regards,
Nigel
(e-mail address removed)