Thank you for several good solutions, as always.
In this approach I will use " or even better < or > to show the start and the end of the string and then be able to see if there are blanks.
But I will save the formula and sub-solutions as well, they can be useful later.
Thanks
Torstein
Den Tirsdag, 27. juni 2017 23.11 skrev "Green 1z@compuserve.com [ExcelVBA]" <ExcelVBA@yahoogroups.com>:
Hi Mark.....
Can you reply to my email please as the answer my affect other members.
Also... You may want to think about trimming your posts :-)
Also... You may want to think about trimming your posts :-)
Lisa
-----Original Message-----
From: Mark Bacheldor m_bacheldor@yahoo.com [ExcelVBA] <ExcelVBA@yahoogroups.com>
To: ExcelVBA <ExcelVBA@yahoogroups.com>
Sent: Tue, Jun 27, 2017 5:45 pm
Subject: Re: Sv: [ExcelVBA] Display strings in messagebox (blank-sensitive)
I like David's idea if you display them in quotes it will show you if there are leading or trailing spaces in the quotes.
--------------------------------------------
On Tue, 6/27/17, Torstein Johnsen sejohnse@yahoo.no [ExcelVBA] <ExcelVBA@yahoogroups.com> wrote:
Subject: Sv: [ExcelVBA] Display strings in messagebox (blank-sensitive)
To: "ExcelVBA@yahoogroups.com" <ExcelVBA@yahoogroups.com>
Date: Tuesday, June 27, 2017, 4:30 AM
My
question/explanation may have been difficult to
understand.
I want to
display the strings in a messagebox (with or without
blanks), but my problem is that I'm not able to see if
the strings have blanks at the start or the end of the
string.
I'm
looking for how to "design" the listing in the
messagebox so that I can see the blanks?
Torstein
From: Mark Bacheldor m_bacheldor@yahoo.com [ExcelVBA] <ExcelVBA@yahoogroups.com>
To: ExcelVBA <ExcelVBA@yahoogroups.com>
Sent: Tue, Jun 27, 2017 5:45 pm
Subject: Re: Sv: [ExcelVBA] Display strings in messagebox (blank-sensitive)
I like David's idea if you display them in quotes it will show you if there are leading or trailing spaces in the quotes.
--------------------------------------------
On Tue, 6/27/17, Torstein Johnsen sejohnse@yahoo.no [ExcelVBA] <ExcelVBA@yahoogroups.com> wrote:
Subject: Sv: [ExcelVBA] Display strings in messagebox (blank-sensitive)
To: "ExcelVBA@yahoogroups.com" <ExcelVBA@yahoogroups.com>
Date: Tuesday, June 27, 2017, 4:30 AM
My
question/explanation may have been difficult to
understand.
I want to
display the strings in a messagebox (with or without
blanks), but my problem is that I'm not able to see if
the strings have blanks at the start or the end of the
string.
I'm
looking for how to "design" the listing in the
messagebox so that I can see the blanks?
Torstein
__._,_.___
Posted by: Torstein Johnsen <sejohnse@yahoo.no>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (11) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
.
__,_._,___
Tidak ada komentar:
Posting Komentar