LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 72
Default Quotes around text in Msgbox

I searched this forum but couldn't find the same situation. I want to
have quotes around some text in other text in a Msgbox. I want the
text in the Msgbox to read,
Question 2 is answered "Other, Please specify" but there is no text in
the adjacent cell. Please enter the data there.
..

I've tried a couple of combinations, the last being:
MsgBox "Question 2 is answered" & ""Other, Please specify"" & "but
there is no text in the adjacent cell. Please enter the data there."

How do I get the quotes in the message box text?

As always, thanks!
 
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 enclose text in a cell in quotes booker@mgt[_2_] Excel Discussion (Misc queries) 7 April 3rd 23 02:26 PM
Write text data to text file without quotes Richard Excel Programming 4 April 28th 08 07:43 PM
saving an excel file as text without text in quotes John Excel Discussion (Misc queries) 2 December 6th 05 06:20 PM
Writing text string with imbedded quotes to a text stream John Wirt[_9_] Excel Programming 2 June 9th 05 01:38 AM
I need to put text in quotes(") Donna[_7_] Excel Programming 3 February 22nd 05 01:45 PM


All times are GMT +1. The time now is 03:18 PM.

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

About Us

"It's about Microsoft Excel"