Calling up a font colour picker with VBA doesn't seem to work (using "Application.Dialogs(xlDialogColorPalette).Show").
A good method is given here: Excel Color Picker - Collection of VBA Code Snippets and Useful Excel Knowledge.
I don't know how to call the procedure, given that arguments are required. I tried a couple of ways as follows but neither worked. Where am I going wrong?
A good method is given here: Excel Color Picker - Collection of VBA Code Snippets and Useful Excel Knowledge.
I don't know how to call the procedure, given that arguments are required. I tried a couple of ways as follows but neither worked. Where am I going wrong?
Code:
Sub Test1()
Color2RGB 256, 256, 256, 256
End Sub
Sub Test2()
Call Color2RGB (256, 256, 256, 256)
End Sub