Looking for eloquent solution: Determine of any control on a page of multipage has been altered (use

K

KR

Using XL XP on Win2000

I have a 4-page multipage control on a userform. Each page has multiple
frames (at least 4) each of which contain optionbuttons (at least 2 per
frame). In addition, there is a textbox on each (multi)page.

When the user changes (multi)pages, I would like to know whether anything on
the current (multi)page has changed (if any optionbuttons were selected, or
any text entered in the textbox). Any suggestions on the best way to do
this? Without a better suggestion, I'll probably code a boolean
("somethingchanged"= true/false) into the change event of every single
control, it just seems like there ought to be a better way.

TIA,
Keith
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Working with GroupName in a control 1
Set focus on field not on active page of a multipage 2
MultiPage Control problem 5
ActiveControl returns "wrong" value if ctrl is on a multipage ctrl 3
activating a page of a multipage control 3
MultiPage exit/change event 2
Loading UserForm Controls (with a twist!) 5
XL2002 - Resetting Checkbox values on Multipage Form 2

Top