I want to know if there is a way to use a completely custom userform,
not the standard form object that comes with VBA. I want to change the
look of the form, the controls, everything...anyone have a clue how (or
if?) it can be done?


---
Message posted from http://www.ExcelForum.com/

Is there a particular reason you want to do this? The
forms are practically built to give you the ability to
change their appearance, so you can make them look however
you'd like. If you're really hell bent on making a whole
new form, have at it, it can be done, but I don't see why
you'd spend the time if there is no functional reason for
wanting a different form. As far as controls are
concerned, learn about ActiveX controls and make your
own. That's not too tough, though the same comment about
functionality applies here too. Apart from that, your
question is too broad to be answered here.


-----Original Message-----
I want to know if there is a way to use a completely
custom userform,
not the standard form object that comes with VBA. I want
to change the
look of the form, the controls, everything...anyone have
a clue how (or
if?) it can be done?


---
Message posted from http://www.ExcelForum.com/

.

HI momiage, something like this?

http://xcelfiles.homestead.com/FormsSearch.html


--
With best regards,
Colo

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
Colo VBA guy! of 'The Road of The Cell Masters' :)

URL:http://www.interq.or.jp/sun/puremis/...astersLink.htm
(Colo)
/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/



"momiage" wrote in message
...
I want to know if there is a way to use a completely custom userform,
not the standard form object that comes with VBA. I want to change the
look of the form, the controls, everything...anyone have a clue how (or
if?) it can be done?


---
Message posted from http://www.ExcelForum.com/