Hi,
I came accross in http://www.cpearson.com/excel/SetParent.aspx site.
I tried to apply the code in the ff steps:
1. create a new form -> copy the code that makes the form a child of the active worksheet window
2. create a new module -> create a test sub that calls Userform1.Show 0
I want to see if the form will be a child of the activesheet.
But when I run the sub, no form appears.
Does anybody successfully tried this?
I'm using Excel 2003.
I came accross in http://www.cpearson.com/excel/SetParent.aspx site.
I tried to apply the code in the ff steps:
1. create a new form -> copy the code that makes the form a child of the active worksheet window
2. create a new module -> create a test sub that calls Userform1.Show 0
I want to see if the form will be a child of the activesheet.
But when I run the sub, no form appears.
Does anybody successfully tried this?
I'm using Excel 2003.