GO GaryFingers
New Member
- Joined
- Jan 19, 2005
- Messages
- 19
I've never used user forms b4 today.
Question is- Can the form 'live', or show on a worksheet?
I have several Active X controls on Sheets, That are a pain.I've been told to get these controls onto a user form. (the controls are activated unwantingly with changes in worksheets)
On my first form, I made a sub -myform.show on This workbook_open sub
and , Whala! it appears to my delight, in the upper left corner of screen ( I set postition to windows default 3). The form appears to be outside of the Excel Application window itself!
Which module, and what code is best to load/show the form (on a sheet)?
Question is- Can the form 'live', or show on a worksheet?
I have several Active X controls on Sheets, That are a pain.I've been told to get these controls onto a user form. (the controls are activated unwantingly with changes in worksheets)
On my first form, I made a sub -myform.show on This workbook_open sub
and , Whala! it appears to my delight, in the upper left corner of screen ( I set postition to windows default 3). The form appears to be outside of the Excel Application window itself!
Which module, and what code is best to load/show the form (on a sheet)?