JohnNZExcel
asked on
Excel VBA - Refresh Modeless Userform
I have created a modeless userform that loads spreadsheet data when it initialises. If the spreadsheet is edited with the form open i would like the data in the userform to update. Is simply adding a "refresh" button on the form (that effectively closes and reopens it) the way to go or is a worksheet change event better?
Chart-Userform.xlsm
Chart-Userform.xlsm
It depends how live you want it to be. A Worksheet_Change event will keep the data more up to date than a button.
ASKER
Thanks for your interest in the Question. The actual project worksheet has approximately 100 drop down boxes that are used for building a session plan and each change will slightly alter the content of the information and chart that is loaded on the userform. I think a button will spare the system resources and make the spreadsheet work faster. What do you think?
Assuming a "refresh" button is the way to go - do you think unloading and then re-opening the form to run the initialize code is the simplest method or can i attach the initialize code to a simple command button on the form and get the same effect?
Assuming a "refresh" button is the way to go - do you think unloading and then re-opening the form to run the initialize code is the simplest method or can i attach the initialize code to a simple command button on the form and get the same effect?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Great, thanks for your assistance