Good morning,

I want to bold and italic the name of active workbook in a message below.
Please help.

Msgbox "I am running this macro in workbook '" & ActiveWorkbook.Name & "."

How can I make the "ActiveWorkbook.Name" to bold and italic?

Thanks.

You have no control over the MsgBox, so you cannot selectively change the
font. You would need to create a userform to do that.

Cheers
Nigel

"AccessHelp" wrote:

Good morning,

I want to bold and italic the name of active workbook in a message below.
Please help.

Msgbox "I am running this macro in workbook '" & ActiveWorkbook.Name & "."

How can I make the "ActiveWorkbook.Name" to bold and italic?

Thanks.

Hi Nigel,

Thanks for your response. So what you are saying is I have to create a form
to message the users, instead of using "Msgbox"?

Thanks.

"Nigel RS" wrote:

You have no control over the MsgBox, so you cannot selectively change the
font. You would need to create a userform to do that.

Cheers
Nigel

"AccessHelp" wrote:

Good morning,

I want to bold and italic the name of active workbook in a message below.
Please help.

Msgbox "I am running this macro in workbook '" & ActiveWorkbook.Name & "."

How can I make the "ActiveWorkbook.Name" to bold and italic?

Thanks.

That is correct, if you want to manipulate the font of your message.

You might find the following a simpler way of emphasising the message,
without changing the font by inserting a space between the message and the
file name?

Also consider change the MsgBox title?

Msgbox "I am running this macro in workbook" & vbcrlf & vbcrlf &
ActiveWorkbook.Name & "."


"AccessHelp" wrote:

Hi Nigel,

Thanks for your response. So what you are saying is I have to create a form
to message the users, instead of using "Msgbox"?

Thanks.

"Nigel RS" wrote:

You have no control over the MsgBox, so you cannot selectively change the
font. You would need to create a userform to do that.

Cheers
Nigel

"AccessHelp" wrote:

Good morning,

I want to bold and italic the name of active workbook in a message below.
Please help.

Msgbox "I am running this macro in workbook '" & ActiveWorkbook.Name & "."

How can I make the "ActiveWorkbook.Name" to bold and italic?

Thanks.

Thanks for additional information.

"Nigel RS" wrote:

That is correct, if you want to manipulate the font of your message.

You might find the following a simpler way of emphasising the message,
without changing the font by inserting a space between the message and the
file name?

Also consider change the MsgBox title?

Msgbox "I am running this macro in workbook" & vbcrlf & vbcrlf &
ActiveWorkbook.Name & "."


"AccessHelp" wrote:

Hi Nigel,

Thanks for your response. So what you are saying is I have to create a form
to message the users, instead of using "Msgbox"?

Thanks.

"Nigel RS" wrote:

You have no control over the MsgBox, so you cannot selectively change the
font. You would need to create a userform to do that.

Cheers
Nigel

"AccessHelp" wrote:

Good morning,

I want to bold and italic the name of active workbook in a message below.
Please help.

Msgbox "I am running this macro in workbook '" & ActiveWorkbook.Name & "."

How can I make the "ActiveWorkbook.Name" to bold and italic?

Thanks.