Thread
:
refreshing a multipage
View Single Post
#
5
Posted to microsoft.public.excel.programming
Nigel[_2_]
external usenet poster
Posts: 735
refreshing a multipage
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?
Reply With Quote
Nigel[_2_]
View Public Profile
Find all posts by Nigel[_2_]