View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
John Bundy John Bundy is offline
external usenet poster
 
Posts: 772
Default 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 ?