Dialogsheets->UserForms, drawing objects


Posted by Katrina on July 20, 2000 6:06 AM

I have a workbook that was originally developed in Excel '95(?). It has dialogsheets that need to be converted to userforms since dialogsheets are no longer supported. The dialogsheets have some diagrams on them that were created with the drawing toolbar. The userform design window doesn't have the drawing toolbar. How do I copy the shapes to the userform and then edit them, or how do I recreate them from scratch on the userform?



Posted by Ryan on July 20, 0100 11:39 AM

Katrina,

Check out this site. John created an add-in that creates a userform from the dialog sheet! Hope this helps!

http://www.j-walk.com/ss/excel/files/developer.htm

Ryan