Userform - Title bar formatting options and other attributes
 

[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

Userform - Title bar formatting options and other attributes
 

The best you can do is to simply remove the caption the frame will still
remain.

Roger on Excel;579790 Wrote:
[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


--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: 1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=160327

Microsoft Office Help

Userform - Title bar formatting options and other attributes
 

Hi Roger,

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

Go to http://www.oaltd.co.uk/Excel/SBXLFrm.htm and download formfun.zip.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

Userform - Title bar formatting options and other attributes
 

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.
--
jb


"Roger on Excel" wrote:

[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

Userform - Title bar formatting options and other attributes
 

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]



On Mon, 7 Dec 2009 08:57:01 -0800, Roger on Excel
wrote:

[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