View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rody Meulman[_3_] Rody Meulman[_3_] is offline
external usenet poster
 
Posts: 14
Default 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