Hello readers.
I'm building an application in Excel. One sheet has a fair number of controls (about 50) to help navigate the user through the application.
Due to the joys of backwards compatability and the need for a treeview control (which, I have subsequently discovered, will not sit on a worksheet in Excel 97 only a form) I need to move all these controls from a worksheet to a new UserForm.
Can anyone suggest an easy way (even perhaps using code) to move all the controls from Worksheet to Form, ideally keeping original names & properties?
Many thanks.
I'm building an application in Excel. One sheet has a fair number of controls (about 50) to help navigate the user through the application.
Due to the joys of backwards compatability and the need for a treeview control (which, I have subsequently discovered, will not sit on a worksheet in Excel 97 only a form) I need to move all these controls from a worksheet to a new UserForm.
Can anyone suggest an easy way (even perhaps using code) to move all the controls from Worksheet to Form, ideally keeping original names & properties?
Many thanks.