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 ?
|
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