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....

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....

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

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

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

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

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