VB Userforms in Office 2007 Same "Style" as Office 2003

[MSOffice2007Tester]

I'm wondering if the userforms created in Visual Basic are updated in Office
2007 to reflect the look of those in the new software. When you maximize the
Paragraph options for example, the pop up box has a new 2007 style (tabs have
yellow line across the top when selected, amoung others...), but when I
insert a new user form in VB using a base Office 2007 document, the style is
the same as Office 2003. How do you create userforms in VB that will be
consistent with the new style of 2007?

I know it's picky, but I like things like this to be consistent

Thanks in advance!!

PS: I'm currently using Office 2007 on test PC at work before a migration
from Office 2003 to 2007, so I'm not sure if this could be creating the
discrepancy.

 

[Cindy M.]

Hi MSOffice2007Tester,

I'm wondering if the userforms created in Visual Basic are updated in Office
2007 to reflect the look of those in the new software. When you maximize the
Paragraph options for example, the pop up box has a new 2007 style (tabs have
yellow line across the top when selected, amoung others...), but when I
insert a new user form in VB using a base Office 2007 document, the style is
the same as Office 2003. How do you create userforms in VB that will be
consistent with the new style of 2007?

Basically, you don't / can't. The core of what VBA offers in Office has not been
updated or changed since it's been introduced. I have no idea if it will be,
eventually. But if you want something "fancier" and "more modern" then you'll
have to use a tool other than VBA (such as create an Add-in in Visual Studio
NET and use Windows Forms for dialog boxes). But even then, there's no simple
or easy way to make it look like Office's dialog boxes.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail