XP Style VBA forms & buttons

[WebServant]

I was just wondering if I can change the looks of VBA forms (in Excel) to look like XP style forms and buttons. Is there a way to do this? I am using Excel 2003.

Cheers

Webservant

[RobDog888]

No, VBA UserForms and controls do not support XP Visual Styles. You could do all the drawing yourself but if the user is using a custom theme then it would be next to impossible to match the theme. Way too much code and work for the minimal visual benefit.

[Radjesh Klauke]

Well.... there is another solution. You could create the buttons with photoshop (whatever) and place them in an imagebox.

[RobDog888]

Yes, that will kind of work as if the user has a custom theme or changes his theme then it wont look legit.

[malik641]

No, VBA UserForms and controls do not support XP Visual Styles.

Do you know if they will? Like under the .NET framework (if relevant)?


Maybe a workaround could be to make the form in VB (with XP styles) and have VBA call the form?

[RobDog888]

VBA userforms are a completely different design then a standard vb.net or vb 5,6 form. Their client area is actually a separate window.

I would think that the UserFoms will fade in their use as other possibilities exist like using vvs.net automation and using a vs.net form instead. I have already tried using VSTO and applying the styles but it only applied it to the msgboxs and no controls or form.