#COMDLG32 HOW TO#
#COMDLG32 CODE#
#COMDLG32 WINDOWS#

Private Sub Command1_Click()Д¬ustomColors = StrConv(cc. Find help installing the file for Windows, useful software, and a forum to ask questions. Second, replace the use of Len with LenB. 'ChooseColorA' (pChoosecolor As CHOOSECOLOR) As LongPtr First, replace every use of Long with LongPtr.

#COMDLG32 CODE#

edu Individually, the code snippets here are in the public domain. How do I access and use this custom colour chooser (image below) in Excel 2010 64-bit (MUST work on 64-bit!) to set cells in Excel 2010 with the colour chosen and store the colour? The image is taken from Excel 2010 64-bit by selecting fill button>more colors>Custom OCX to C:WindowsSysWOW64 then Start Menu > Run > regsvr32 C:WindowsSysWOW64COMDLG32.

#COMDLG32 HOW TO#

Does anyone know how to get this working on a 64-bit machine or if it's even possible? Perhaps there's a new library?Д®dit: Slight rewording with offer of bounty. I've also tried changing some LONG types to LONGPTR with no success. This runs ok but doesn't show the dialog. ReDim CustomColors(0 To 16 * 4 - 1) As ByteДЇor i = LBound(CustomColors) To UBound(CustomColors) 'ChooseColorA' (pChoosecolor As CHOOSECOLOR) As LongД¬c.lpCustColors = StrConv(CustomColors, vbUnicode)ДЄpplication.Caption = 'RGB Value User Chose: ' & Str$(cc.rgbResult)ДЄpplication.BackColor = cc.rgbResult ' Visual Basic only ****ДЄpplication.Section(0).BackColor = cc.rgbResult ' Access only **********Д¬ustomColors = StrConv(cc.lpCustColors, vbFromUnicode) I tried using Advance Mart, A-Starter and A-Text none of them work, all of them come up with an error that a component is missing.

#COMDLG32 WINDOWS#

Private Declare PtrSafe Function ChooseColorAPI Lib 'comdlg32.dll' Alias _ Selected Items Only Microsoft Common Dialog Control 6.0 Location : C : WINDOWS SYSTEM COMDLG32.OCX OK Cancel Apply Figure 7-1 : You must add the. Code on both sites work fine in Excel 2003 So if comdlg64. Using google reveals that there a host of viruses floating around on the net by that name. Use comdlg64.dll instead (if there is such a dll). I'm trying to adapt the code in either here or here to open the custom colour palette in Excel 2010 64-bit but cannot get it to work. AFAIK 32-bit dll's cannot be used by a 64-bit application.

Comdlg32