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
Printable View
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
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.
Well.... there is another solution. You could create the buttons with photoshop (whatever) and place them in an imagebox. ;)
Yes, that will kind of work as if the user has a custom theme or changes his theme then it wont look legit.
Do you know if they will? Like under the .NET framework (if relevant)?Quote:
Originally Posted by RobDog888
Maybe a workaround could be to make the form in VB (with XP styles) and have VBA call the form?
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. :sick:
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.