In Excel VBA, I have created a userform with some textboxes, comman
buttons etc. And now I wanna transfer it to ms Visual Basic(V5.0) for
and make it a .exe file.

I tried the "export file" function in VBA and save the userform i
harddisk with a extension name .frm, and it seems MS VB can open th
.frm file, everything in MS VB goes ok, you can check the properties
view the controls,...., and then it breaks down all of sudden and send
you an error message saying it has encountered some problem and V
should be closed.

Is there a compatible issue between Excel VBA and MS VB? you
enlightment is appreciated

--
orbi
-----------------------------------------------------------------------
orbit's Profile: http://www.excelforum.com/member.php...fo&userid=1511
View this thread: http://www.excelforum.com/showthread.php?threadid=26748

Not done this myself, but I have heard that you can import them into VB6 as
MSForms designers and they then work okay.

--

HTH

RP

"orbit" wrote in message
...

In Excel VBA, I have created a userform with some textboxes, command
buttons etc. And now I wanna transfer it to ms Visual Basic(V5.0) form
and make it a .exe file.

I tried the "export file" function in VBA and save the userform in
harddisk with a extension name .frm, and it seems MS VB can open the
frm file, everything in MS VB goes ok, you can check the properties,
view the controls,...., and then it breaks down all of sudden and sends
you an error message saying it has encountered some problem and VB
should be closed.

Is there a compatible issue between Excel VBA and MS VB? your
enlightment is appreciated.


--
orbit
------------------------------------------------------------------------
orbit's Profile:
http://www.excelforum.com/member.php...o&userid=15116
View this thread: http://www.excelforum.com/showthread...hreadid=267482