Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

  #2   Report Post  
Posted to microsoft.public.excel.programming
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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to remove spacing in between text Calculate Date range Excel Worksheet Functions 6 April 8th 09 07:01 AM
MsgBox Spacing of Characters Chuckles123[_30_] Excel Programming 1 October 9th 04 10:29 PM
MsgBox Spacing of Characters Chuckles123[_29_] Excel Programming 0 October 8th 04 05:09 AM
MsgBox Spacing of Characters Chuckles123[_28_] Excel Programming 1 October 8th 04 04:14 AM
MsgBox Properties Michael Smith Excel Programming 0 June 8th 04 04:30 PM


All times are GMT +1. The time now is 06:53 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"