$$Excel-Macros$$ Re: Shapes in Form

2009-08-05 Thread Ajit Navre
Subject: $$Excel-Macros$$ Re: Shapes in Form Hi, If you can please provide a sample file of the same, it will help us to find the solution. Regrds, Deepak On Wed, Aug 5, 2009 at 1:56 AM, Tim wrote: Hello all, I'm attempting to have a window pop up when the user clicks a command b

$$Excel-Macros$$ Re: Shapes in Form

2009-08-05 Thread Deepak Rai
Hi, If you can please provide a sample file of the same, it will help us to find the solution. Regrds, Deepak On Wed, Aug 5, 2009 at 1:56 AM, Tim wrote: > > Hello all, > I'm attempting to have a window pop up when the user clicks a > command button on the sheet. The hurdle I have come to is

$$Excel-Macros$$ Re: Shapes in Form

2009-08-05 Thread Ajit Navre
Take a look at the link below:- http://www.andypope.info/vba/userformdraw.htm The approach is, copying the shapes from the worksheet to clipboard, and then reading the clipboard and place the clipboard BitMap/metafile on the form as an OLE Picture. Regards Ajit -Original Message- Fro