ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Bold Font (https://www.excelbanter.com/excel-programming/359024-bold-font.html)

scantor145[_25_]

Bold Font
 

Visual Basic 6.3 w/Excel 2003

I have a User Form that has a label control

UserForm = frmEasyLyteQC
Name = lblInstruction
Caption = Open File


When the user performs a certain action I would like the label font t
change to a bold font

I used the following:


Code
-------------------
frmEasyLyteQC.lblInstruction.Font.Bol
-------------------


But when the program executes I get a Complile error: Invalid use o
property.

What's wrong ? Any way around it

--
scantor14
-----------------------------------------------------------------------
scantor145's Profile: http://www.excelforum.com/member.php...fo&userid=1476
View this thread: http://www.excelforum.com/showthread.php?threadid=53339


Peter T

Bold Font
 
frmEasyLyteQC.lblInstruction.Font.Bold = True ' or False

Regards,
Peter T

"scantor145" wrote
in message ...

Visual Basic 6.3 w/Excel 2003

I have a User Form that has a label control

UserForm = frmEasyLyteQC
Name = lblInstruction
Caption = Open File


When the user performs a certain action I would like the label font to
change to a bold font

I used the following:


Code:
--------------------
frmEasyLyteQC.lblInstruction.Font.Bold
--------------------


But when the program executes I get a Complile error: Invalid use of
property.

What's wrong ? Any way around it?


--
scantor145
------------------------------------------------------------------------
scantor145's Profile:

http://www.excelforum.com/member.php...o&userid=14766
View this thread: http://www.excelforum.com/showthread...hreadid=533396




Tom Ogilvy

Bold Font
 
similar code worked fine for me:

Private Sub UserForm_Initialize()
Me.Label1.Font.Bold = True
Me.Label1.Caption = "My Dog is big"
End Sub

--
Regards,
Tom Ogilvy


"scantor145" wrote:


Visual Basic 6.3 w/Excel 2003

I have a User Form that has a label control

UserForm = frmEasyLyteQC
Name = lblInstruction
Caption = Open File


When the user performs a certain action I would like the label font to
change to a bold font

I used the following:


Code:
--------------------
frmEasyLyteQC.lblInstruction.Font.Bold
--------------------


But when the program executes I get a Complile error: Invalid use of
property.

What's wrong ? Any way around it?


--
scantor145
------------------------------------------------------------------------
scantor145's Profile: http://www.excelforum.com/member.php...o&userid=14766
View this thread: http://www.excelforum.com/showthread...hreadid=533396




All times are GMT +1. The time now is 09:19 PM.

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