Msgbox text properties & Spacing
 

I have the following code


Code:
--------------------
NInoget:

Message1 = "Please input the National Insurance Number"
Title = "NATIONAL INSURANCE NUMBER"
NINO = InputBox(Message1, Title, Default)

Message2 = "The NI no you have entered is: " & NINO & " Please confirm this is correct before continuing"
rep = MsgBox(Message2, vbYesNoCancel, "NI No")
If rep = vbYes Then GoTo continue
If rep = vbNo Then GoTo NInoget
If rep = vbCancel Then End: MsgBox ("Operation cancelled")
--------------------


I would like to make BOLD "part" of the message in a message box. The
part is NINO in message2. Any iudeas how to do this?

Additonally, the part " Please confirm this is correct before
continuing" I would like on a new line.

thanks


--
rocket0612
------------------------------------------------------------------------
rocket0612's Profile: http://www.excelforum.com/member.php...o&userid=19492
View this thread: http://www.excelforum.com/showthread...hreadid=487138

Msgbox text properties & Spacing
 

rocket0612,


I would like to make BOLD "part" of the message in a message box. The
part is NINO in message2. Any iudeas how to do this?

As far as i know this is not possible, maybe you should consider to use a
userform instead.


Additonally, the part " Please confirm this is correct before
continuing" I would like on a new line.

Change the line to:
Message2 = "The NI no you have entered is: " & NINO & vbcr & " Please
confirm this is correct before continuing"

Grtz,
Rody


"rocket0612" <rocket0612.1yw5ez_1132650902.8054@ex
celforum-nospam.com schreef in bericht
...

I have the following code


Code:
--------------------
NInoget:

Message1 = "Please input the National Insurance Number"
Title = "NATIONAL INSURANCE NUMBER"
NINO = InputBox(Message1, Title, Default)

Message2 = "The NI no you have entered is: " & NINO & " Please confirm
this is correct before continuing"
rep = MsgBox(Message2, vbYesNoCancel, "NI No")
If rep = vbYes Then GoTo continue
If rep = vbNo Then GoTo NInoget
If rep = vbCancel Then End: MsgBox ("Operation cancelled")
--------------------


I would like to make BOLD "part" of the message in a message box. The
part is NINO in message2. Any iudeas how to do this?

Additonally, the part " Please confirm this is correct before
continuing" I would like on a new line.

thanks


--
rocket0612
------------------------------------------------------------------------
rocket0612's Profile:
http://www.excelforum.com/member.php...o&userid=19492
View this thread: http://www.excelforum.com/showthread...hreadid=487138

Msgbox text properties & Spacing
 

thanks alot Rody


--
rocket0612
------------------------------------------------------------------------
rocket0612's Profile: http://www.excelforum.com/member.php...o&userid=19492
View this thread: http://www.excelforum.com/showthread...hreadid=487138