| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Font to be larger in line of VBA
MsgBox "Welcome " & .UserName & " to the File.", vbInformation
Is there a Way to change the .Username to have a Larger or Bold Font? I want to make this stand out MORE than the surrounding text. Corey.... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Font to be larger in line of VBA
I did a learn macro and got the following code. Modify this code as needed.
I jsut entered the text abc followed by some spaces , changed font size, then typed efg. ActiveCell.FormulaR1C1 = "abc efg" With ActiveCell.Characters(Start:=1, Length:=8).Font .Name = "Arial" .FontStyle = "Regular" .Size = 10 .Strikethrough = False .Superscript = False .Subscript = False .OutlineFont = False .Shadow = False .Underline = xlUnderlineStyleNone .ColorIndex = xlAutomatic End With With ActiveCell.Characters(Start:=9, Length:=3).Font .Name = "Arial" .FontStyle = "Regular" .Size = 16 .Strikethrough = False .Superscript = False .Subscript = False .OutlineFont = False .Shadow = False .Underline = xlUnderlineStyleNone .ColorIndex = xlAutomatic End With Range("F108").Select "Corey" wrote: MsgBox "Welcome " & .UserName & " to the File.", vbInformation Is there a Way to change the .Username to have a Larger or Bold Font? I want to make this stand out MORE than the surrounding text. Corey.... |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Font to be larger in line of VBA
Not in a msgbox.
Maybe you could design your own userform???? Corey wrote: MsgBox "Welcome " & .UserName & " to the File.", vbInformation Is there a Way to change the .Username to have a Larger or Bold Font? I want to make this stand out MORE than the surrounding text. Corey.... -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Font to be larger in line of VBA
To extend Dave's answer with a possible workaround
MsgBox "Welcome " & Ucase(.UserName) & " to the File.", vbInformation Not that attractive, but it would stand out. -- Regards, Tom Ogilvy "Dave Peterson" wrote in message ... Not in a msgbox. Maybe you could design your own userform???? Corey wrote: MsgBox "Welcome " & .UserName & " to the File.", vbInformation Is there a Way to change the .Username to have a Larger or Bold Font? I want to make this stand out MORE than the surrounding text. Corey.... -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Font to be larger in line of VBA
Or maybe putting them on a separate line would help:
MsgBox "Welcome" & vblf & Ucase(.UserName) & vblf & "to the File.", _ vbInformation (or surround the name with asterisks???) Tom Ogilvy wrote: To extend Dave's answer with a possible workaround MsgBox "Welcome " & Ucase(.UserName) & " to the File.", vbInformation Not that attractive, but it would stand out. -- Regards, Tom Ogilvy "Dave Peterson" wrote in message ... Not in a msgbox. Maybe you could design your own userform???? Corey wrote: MsgBox "Welcome " & .UserName & " to the File.", vbInformation Is there a Way to change the .Username to have a Larger or Bold Font? I want to make this stand out MORE than the surrounding text. Corey.... -- Dave Peterson -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Font to be larger in line of VBA
Like your reply thanks Tom
"Tom Ogilvy" wrote in message ... To extend Dave's answer with a possible workaround MsgBox "Welcome " & Ucase(.UserName) & " to the File.", vbInformation Not that attractive, but it would stand out. -- Regards, Tom Ogilvy "Dave Peterson" wrote in message ... Not in a msgbox. Maybe you could design your own userform???? Corey wrote: MsgBox "Welcome " & .UserName & " to the File.", vbInformation Is there a Way to change the .Username to have a Larger or Bold Font? I want to make this stand out MORE than the surrounding text. Corey.... -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Font to be larger in line of VBA
(and use multiple labels, too)
Corey wrote: MsgBox "Welcome " & .UserName & " to the File.", vbInformation Is there a Way to change the .Username to have a Larger or Bold Font? I want to make this stand out MORE than the surrounding text. Corey.... -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I reformat all comments to a larger font? | Excel Worksheet Functions | |||
| How do you format a larger font for cell comments ? | Excel Worksheet Functions | |||
| How do I make the font on worksheet tab labels larger? | Excel Discussion (Misc queries) | |||
| How do I get a larger font in the HELP panels? | Excel Discussion (Misc queries) | |||
| Is it possible to make comments font larger by default? | Excel Discussion (Misc queries) | |||
Hybrid Mode
