Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checkbox question
I would like to know if the color of the checkbox can be changed from white
to something else in code? I have a page many checkboxes and would like to alternate the color of checks so it would be easier on the eye. I tried the "backcolor" but client does not like it. Was wondering if there is anything else? Thank you in advance for any help you can provide. Thank you. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checkbox question
There is a forecolor ( the text color) and the backcolor (the area not in the
box area). You can see the options by creating a userform and placing a checkbox on the userform. The user VBA Vmenu and select View - Properties. then select the checkbox and yo will see all the options. Yo can manually change the forecolor and backcolor throughthe properties window. there is a drop down menu inside the property window for both of these properties. "TotallyConfused" wrote: I would like to know if the color of the checkbox can be changed from white to something else in code? I have a page many checkboxes and would like to alternate the color of checks so it would be easier on the eye. I tried the "backcolor" but client does not like it. Was wondering if there is anything else? Thank you in advance for any help you can provide. Thank you. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checkbox question
I should have been more specific. The checkboxes I am referring to are the
ones used in Excel Userform and there is no "forecolor" for these. Is there any other options? Thank you. "Joel" wrote: There is a forecolor ( the text color) and the backcolor (the area not in the box area). You can see the options by creating a userform and placing a checkbox on the userform. The user VBA Vmenu and select View - Properties. then select the checkbox and yo will see all the options. Yo can manually change the forecolor and backcolor throughthe properties window. there is a drop down menu inside the property window for both of these properties. "TotallyConfused" wrote: I would like to know if the color of the checkbox can be changed from white to something else in code? I have a page many checkboxes and would like to alternate the color of checks so it would be easier on the eye. I tried the "backcolor" but client does not like it. Was wondering if there is anything else? Thank you in advance for any help you can provide. Thank you. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checkbox question
I am sorry, there is a "forecolor" in Userform properties for checkboxes but
it only affects the text. Any other option? thank you. "TotallyConfused" wrote: I should have been more specific. The checkboxes I am referring to are the ones used in Excel Userform and there is no "forecolor" for these. Is there any other options? Thank you. "Joel" wrote: There is a forecolor ( the text color) and the backcolor (the area not in the box area). You can see the options by creating a userform and placing a checkbox on the userform. The user VBA Vmenu and select View - Properties. then select the checkbox and yo will see all the options. Yo can manually change the forecolor and backcolor throughthe properties window. there is a drop down menu inside the property window for both of these properties. "TotallyConfused" wrote: I would like to know if the color of the checkbox can be changed from white to something else in code? I have a page many checkboxes and would like to alternate the color of checks so it would be easier on the eye. I tried the "backcolor" but client does not like it. Was wondering if there is anything else? Thank you in advance for any help you can provide. Thank you. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checkbox question
Look again for the BackColor property.
TotallyConfused wrote: I am sorry, there is a "forecolor" in Userform properties for checkboxes but it only affects the text. Any other option? thank you. "TotallyConfused" wrote: I should have been more specific. The checkboxes I am referring to are the ones used in Excel Userform and there is no "forecolor" for these. Is there any other options? Thank you. "Joel" wrote: There is a forecolor ( the text color) and the backcolor (the area not in the box area). You can see the options by creating a userform and placing a checkbox on the userform. The user VBA Vmenu and select View - Properties. then select the checkbox and yo will see all the options. Yo can manually change the forecolor and backcolor throughthe properties window. there is a drop down menu inside the property window for both of these properties. "TotallyConfused" wrote: I would like to know if the color of the checkbox can be changed from white to something else in code? I have a page many checkboxes and would like to alternate the color of checks so it would be easier on the eye. I tried the "backcolor" but client does not like it. Was wondering if there is anything else? Thank you in advance for any help you can provide. Thank you. -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checkbox question
Did you click on Palette in the Backcolor option? It offers the 56 color
varieties. The default for the Backcolor is System which is a limited number of colors and tones. "TotallyConfused" wrote in message ... I would like to know if the color of the checkbox can be changed from white to something else in code? I have a page many checkboxes and would like to alternate the color of checks so it would be easier on the eye. I tried the "backcolor" but client does not like it. Was wondering if there is anything else? Thank you in advance for any help you can provide. Thank you. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checkbox question
Private Sub TextBox1_Change()
If IsNumeric(TextBox1.text) Then TextBox1.BackColor = -2147483643 ElseIf TextBox1.text = "" Then Else TextBox1.BackColor = vbRed End If End Sub "TotallyConfused" wrote: I would like to know if the color of the checkbox can be changed from white to something else in code? I have a page many checkboxes and would like to alternate the color of checks so it would be easier on the eye. I tried the "backcolor" but client does not like it. Was wondering if there is anything else? Thank you in advance for any help you can provide. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CheckBox question | Excel Programming | |||
Checkbox question | Excel Discussion (Misc queries) | |||
Checkbox question | Excel Programming | |||
CheckBox question | Excel Programming | |||
CheckBox question | Excel Programming |