ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Custom userforms (https://www.excelbanter.com/excel-programming/285378-custom-userforms.html)

momiage

Custom userforms
 
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/


JoJo the Dancing Monkey

Custom userforms
 
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/

.


Colo

Custom userforms
 
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/




All times are GMT +1. The time now is 03:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com