Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to remove spacing in between text | Excel Worksheet Functions | |||
MsgBox Spacing of Characters | Excel Programming | |||
MsgBox Spacing of Characters | Excel Programming | |||
MsgBox Spacing of Characters | Excel Programming | |||
MsgBox Properties | Excel Programming |