Is it possible to have XP Styles on an Excel VBA form? How is this done?

Hi

I think it is hard to do that.
So far we enable the XP styles by using the manifest file in the unmanaged
code.
That is for the controls in the comctl32.ocx.
Here is KB link for your reference.
INFO: Visual Basic 6.0 Does Not Support Windows XP Themes or Visual Styles
(309366)
http://support.microsoft.com/default...B;EN-US;309366

For excel, if we add the manifest file as above and named it as
Excel.exe.manifest and save it where the excel.exe is located.
If we use the controls from comctl32.ocx,e.g. Microsoft Slider Control,
Microsoft StatusBar control, it will be enable the XP Style.
But as above it is not supported.

In addition, the Control in the default control which will be added onto
the UserForm is not from the comctl32.ocx, it is Office buildin control, so
that did not apply to the scenario.

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

As Peter has indicated, you cannot use XP Styles except if you us
control ocxs/dlls that support this.

I have done this with the progressbar. You need to create this via Wi
API's using the progress control from the comctl32.dll Version 6.0 i
conjunction with the manifest.
As Peter has said the controls supported in this method are Microsof
Slider Control, Microsoft StatusBar control and a few more. For button
I beleive that is possible but requires a lot more work in the API area

--
Ivan F Moal

-----------------------------------------------------------------------
Ivan F Moala's Profile: http://www.excelforum.com/member.php...nfo&userid=195
View this thread: http://www.excelforum.com/showthread.php?threadid=38027