Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Spin Button to Change Label between Normal and BOLD
How (if able) can i set SpinButton1 to Change Label2 and label 3 to be either Normal or Bold font ?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Spin Button to Change Label between Normal and BOLD
Not sure if you wanted bold on up, down, or both but it is easy to do by
modifying the change to spinup or spin down. Here is the code to change label 2 from one to the other with each click in any direction. Copy and paste the if statement and change label2 to label3 to do both at the same time. Private Sub SpinButton1_Change() If Label2.Font.Bold = True Then Label2.Font.Bold = False Else Label2.Font.Bold = True End Sub -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "Corey" wrote: How (if able) can i set SpinButton1 to Change Label2 and label 3 to be either Normal or Bold font ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scroll Bar / Spin Button Small Change value | Excel Programming | |||
how do i make one part of my formula bold and the other normal? | Excel Worksheet Functions | |||
Spin Button control change capture in ThisWorkbook Module | Excel Programming | |||
Spin Button... | Excel Programming | |||
Using bold and normal font within one cell | Excel Programming |