ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Spin Button to Change Label between Normal and BOLD (https://www.excelbanter.com/excel-programming/388374-spin-button-change-label-between-normal-bold.html)

Corey

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 ?



John Bundy

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 ?





All times are GMT +1. The time now is 02:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com