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?

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?

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?

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?

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




"Charlie" wrote in message
...
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?