Spin Button to Change Label between Normal and BOLD

C

Corey

How (if able) can i set SpinButton1 to Change Label2 and label 3 to be either Normal or Bold font ?
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Spin button to scroll up&down a database with a userform 7
SpinButton Excel 2002 bug? 1
spin button 1
Label controls change apparent font size when moved up/down 3
SpinButton Incrementing time behaviour 4
Concantenate which keeps bold of some parts. 5
Search and change font color to Red and bold it 1
Spin button 4

Top