![]() |
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 |
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 |
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