Skin Framework - Does SkinFramework support EXCEL Userform ?

Print Page | Close Window

Does SkinFramework support EXCEL Userform ?

Printed From: Codejock Forums
Category: Codejock Products
Forum Name: Skin Framework
Forum Description: Topics Related to Codejock Skin Framework
URL: http://forum.codejock.com/forum_posts.asp?TID=17172
Printed Date: 26 June 2024 at 12:08pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Does SkinFramework support EXCEL Userform ?

Posted By: msseo
Subject: Does SkinFramework support EXCEL Userform ?
Date Posted: 30 August 2010 at 12:39am

Hi.

I applied Skin Activex to my Excel Userform.

Most of the functionalities work fine except one problem.

After applying skin and typing some function like "=SUM(a1,a2)",

Range(name) area was changed to unacceptable .

And Excel crashed after exit sessionl.

- excel : 2007

- Skin Framework 13.4

- skin : WinXP.Royale.cjstyles

- OS : WinXP Prof.

Would you tell me about this ?

Best Regards.

Replies:

Posted By: auto160
Date Posted: 02 March 2011 at 7:17am

yes:

'Find the Dialog's Window

Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long

Private Sub UserForm_Click()

Dim Hwnd As Long

Hwnd = FindWindow("ThunderDFrame", Me.Caption) 'UserForm

SkinFramework1.LoadSkin ActiveWorkbook.Path & "\Office2007.cjstyles", ""

SkinFramework1.ApplyWindow Me.Hwnd

End Sub