Userform - Title bar formatting options and other attributes

[Roger on Excel]

[Excel 2003]

I use userforms in my spreadsheets.

I have a main "Dashboard" userform from which I call up other userforms.

What I would like is to be able to remove the title bar from the main
userform.

Is there a way to do this? Ideally, I would still like to retain the close
button in the corner (and even change its format (to look like Windows 95
close button icon)

I would be interested to learn of any links to tutorials or examples on how
to format userform attributes of these kind.

can anyone help?

Thanks, Roger

 

[john]

Roger,
have a look at this site:
http://www.oaltd.co.uk/Excel/Default.htm

There is an item in the ist "formFun.zip" you can download for free. Should
give you some ideas what you can be done with userforms.

 

[Chip Pearson]

See the example code and downloadable function library at
http://www.cpearson.com/excel/formcontrol.aspx . This code will allow
you to do what you want and lots more stuff.

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]