Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 363
Default 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   Report Post  
Posted to microsoft.public.excel.programming
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 ?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Scroll Bar / Spin Button Small Change value PCH Excel Programming 1 October 4th 06 06:57 AM
how do i make one part of my formula bold and the other normal? niquey Excel Worksheet Functions 6 March 27th 06 03:22 PM
Spin Button control change capture in ThisWorkbook Module STEVE BELL Excel Programming 0 September 12th 05 09:35 PM
Spin Button... scottnshelly[_25_] Excel Programming 4 April 30th 04 07:49 AM
Using bold and normal font within one cell Paul Excel Programming 2 January 8th 04 07:06 PM


All times are GMT +1. The time now is 01:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"