check1
asked on
Change color on controls
With the commondialog control I want to change the colors of command buttons, labels, etc. The code I was given works great for fonts but I get error messages when i apply it to colors.
Form3!dlg.ShowColor
Dim myControl As CommandButton' this does not work even If I put control or label here!
On Error GoTo Trap
For Each myControl In Form1
myControl.BackColor = Form3!dlg.Color
Next
'Exit here
Trap:
Err.Clear
Resume Next
thanks
Form3!dlg.ShowColor
Dim myControl As CommandButton' this does not work even If I put control or label here!
On Error GoTo Trap
For Each myControl In Form1
myControl.BackColor = Form3!dlg.Color
Next
'Exit here
Trap:
Err.Clear
Resume Next
thanks
Not all controls have a settable backcolor..... commandbuttons being one of them unless the style is set to graphical!
check1,
you have an error before the code "on error goto ..."
Form3!dlg.ShowColor should be form3.dlg.showcolor?
Dim myControl as Control is OK.
What error message you get?
you have an error before the code "on error goto ..."
Form3!dlg.ShowColor should be form3.dlg.showcolor?
Dim myControl as Control is OK.
What error message you get?
What anthonyc said is true... But it is OK because of your errortrapping. When no back color, error occurs, and it will automatically clear the error and goto the next control.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I don't know, I can just say If I use the same code for fonts it works, let me try you suggesion.
Check1
Check1
ASKER
Thanks!
CHECK!
CHECK!