Hi venkat,
So far as I know, in VBA IDE, there is no one form containing the "minimize" button. My suggestion is: you can develop one ActiveX control which can
pop up one window with minimize button and then expose some interfaces and properties. Then in VBA IDE, you can add this control into your form
and pass the Excel data into the ActiveX conrol through these interfaces and properties to perform the operations.
I agree with Peter. You can use Win32 API to do so. However, this way, it will be very time-consuming and not easy to operate raw C data type in
VBA.
Please feel free to let me know if you have any further questions.
Best Regards,
Wei-Dong Xu
Microsoft Product Support Services
Get Secure! -
www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.