LinkBack URL
About LinkBacks
Microsoft excel 2013
I would like to use the multipage option for userinput for several different settings.
Can you distinguish between textbox events per page, and then run macro's belonging to that page?
Changes on pages trigger an event
Microsoft excel 2013
I would like to use the multipage option for userinput for several different settings.
Can you distinguish between textbox events per page, and then run macro's belonging to that page?
The broad answer is yes - however more info would be useful - e.g. I presume you are basing the Multipage on a UserForm as the parent envelope.
Please do not use it 'embeded' directly on the sheet.
I have attached a couple of examples that may assist you.
Post back on this site if you want further help.
Torachan,
Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.
Okay, this gives me a lot to think about, thanks.
Sofar I was thinking to use the "CEventclass" in a classmodule to directly update the changed data on any userform/page to the sheet/cell is has to be stored in.
By using the CEventclass try reducing the programming, and with distinguishing on wich page a change was made try reducing the update time.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks