form class

[jim c]

is it possible to create a form in visual basic 6.0 and
import the form into excel vba? i tried and got an
error "form class not supported"... all i want is a
maximize button for userform... lol

 

[Rob Bovey]

is it possible to create a form in visual basic 6.0 and
import the form into excel vba? i tried and got an
error "form class not supported"... all i want is a
maximize button for userform... lol

No, this isn't possible. VBA and VB6 use two completely different forms
packages. If you want to show a VB6 form in Excel you have to package that
form up into an ActiveX DLL and call it from your VBA program.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *