View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rocket0612[_5_] rocket0612[_5_] is offline
external usenet poster
 
Posts: 1
Default 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