Selasa, 27 Juni 2017

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



Den Tirsdag, 27. juni
2017 8.06 skrev "'David Grugeon'
grugeon@gmail.com [ExcelVBA]"
<ExcelVBA@yahoogroups.com>:



 









You can use the TRIM
function to remove the blanks.
 RegardsDavid Grugeon0429 029 836  From:
ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com]

Sent: Tuesday, 27 June 2017 3:09
PM
To: ExcelVBA@yahoogroups.com
Subject: [ExcelVBA] Display strings in
messagebox (blank-sensitive)  


 
I
use Excel to manipulate several strings and the result is
sensitive for blanks at the start and the end of the
strings.
 That means I like to know if there
are blanks when the strings are listed in a
messagebox.
 Do
anyone have a good idea how I can list the strings in a
messagebox so that I know if there are blanks to the left or
to the right of the string?
 regards
 Torstein
 
























#yiv5724798713 #yiv5724798713 --
#yiv5724798713ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv5724798713 #yiv5724798713ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv5724798713 #yiv5724798713ygrp-mkp #yiv5724798713hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv5724798713 #yiv5724798713ygrp-mkp #yiv5724798713ads {
margin-bottom:10px;}

#yiv5724798713 #yiv5724798713ygrp-mkp .yiv5724798713ad {
padding:0 0;}

#yiv5724798713 #yiv5724798713ygrp-mkp .yiv5724798713ad p {
margin:0;}

#yiv5724798713 #yiv5724798713ygrp-mkp .yiv5724798713ad a {
color:#0000ff;text-decoration:none;}
#yiv5724798713 #yiv5724798713ygrp-sponsor
#yiv5724798713ygrp-lc {
font-family:Arial;}

#yiv5724798713 #yiv5724798713ygrp-sponsor
#yiv5724798713ygrp-lc #yiv5724798713hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv5724798713 #yiv5724798713ygrp-sponsor
#yiv5724798713ygrp-lc .yiv5724798713ad {
margin-bottom:10px;padding:0 0;}

#yiv5724798713 #yiv5724798713actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv5724798713 #yiv5724798713activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv5724798713 #yiv5724798713activity span {
font-weight:700;}

#yiv5724798713 #yiv5724798713activity span:first-child {
text-transform:uppercase;}

#yiv5724798713 #yiv5724798713activity span a {
color:#5085b6;text-decoration:none;}

#yiv5724798713 #yiv5724798713activity span span {
color:#ff7900;}

#yiv5724798713 #yiv5724798713activity span
.yiv5724798713underline {
text-decoration:underline;}

#yiv5724798713 .yiv5724798713attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv5724798713 .yiv5724798713attach div a {
text-decoration:none;}

#yiv5724798713 .yiv5724798713attach img {
border:none;padding-right:5px;}

#yiv5724798713 .yiv5724798713attach label {
display:block;margin-bottom:5px;}

#yiv5724798713 .yiv5724798713attach label a {
text-decoration:none;}

#yiv5724798713 blockquote {
margin:0 0 0 4px;}

#yiv5724798713 .yiv5724798713bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv5724798713 .yiv5724798713bold a {
text-decoration:none;}

#yiv5724798713 dd.yiv5724798713last p a {
font-family:Verdana;font-weight:700;}

#yiv5724798713 dd.yiv5724798713last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv5724798713 dd.yiv5724798713last p
span.yiv5724798713yshortcuts {
margin-right:0;}

#yiv5724798713 div.yiv5724798713attach-table div div a {
text-decoration:none;}

#yiv5724798713 div.yiv5724798713attach-table {
width:400px;}

#yiv5724798713 div.yiv5724798713file-title a, #yiv5724798713
div.yiv5724798713file-title a:active, #yiv5724798713
div.yiv5724798713file-title a:hover, #yiv5724798713
div.yiv5724798713file-title a:visited {
text-decoration:none;}

#yiv5724798713 div.yiv5724798713photo-title a,
#yiv5724798713 div.yiv5724798713photo-title a:active,
#yiv5724798713 div.yiv5724798713photo-title a:hover,
#yiv5724798713 div.yiv5724798713photo-title a:visited {
text-decoration:none;}

#yiv5724798713 div#yiv5724798713ygrp-mlmsg
#yiv5724798713ygrp-msg p a span.yiv5724798713yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv5724798713 .yiv5724798713green {
color:#628c2a;}

#yiv5724798713 .yiv5724798713MsoNormal {
margin:0 0 0 0;}

#yiv5724798713 o {
font-size:0;}

#yiv5724798713 #yiv5724798713photos div {
float:left;width:72px;}

#yiv5724798713 #yiv5724798713photos div div {
border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}

#yiv5724798713 #yiv5724798713photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv5724798713 #yiv5724798713reco-category {
font-size:77%;}

#yiv5724798713 #yiv5724798713reco-desc {
font-size:77%;}

#yiv5724798713 .yiv5724798713replbq {
margin:4px;}

#yiv5724798713 #yiv5724798713ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#yiv5724798713 #yiv5724798713ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv5724798713 #yiv5724798713ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv5724798713 #yiv5724798713ygrp-mlmsg select,
#yiv5724798713 input, #yiv5724798713 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv5724798713 #yiv5724798713ygrp-mlmsg pre, #yiv5724798713
code {
font:115% monospace;}

#yiv5724798713 #yiv5724798713ygrp-mlmsg * {
line-height:1.22em;}

#yiv5724798713 #yiv5724798713ygrp-mlmsg #yiv5724798713logo {
padding-bottom:10px;}


#yiv5724798713 #yiv5724798713ygrp-msg p a {
font-family:Verdana;}

#yiv5724798713 #yiv5724798713ygrp-msg
p#yiv5724798713attach-count span {
color:#1E66AE;font-weight:700;}

#yiv5724798713 #yiv5724798713ygrp-reco
#yiv5724798713reco-head {
color:#ff7900;font-weight:700;}

#yiv5724798713 #yiv5724798713ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv5724798713 #yiv5724798713ygrp-sponsor #yiv5724798713ov
li a {
font-size:130%;text-decoration:none;}

#yiv5724798713 #yiv5724798713ygrp-sponsor #yiv5724798713ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv5724798713 #yiv5724798713ygrp-sponsor #yiv5724798713ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv5724798713 #yiv5724798713ygrp-text {
font-family:Georgia;}

#yiv5724798713 #yiv5724798713ygrp-text p {
margin:0 0 1em 0;}

#yiv5724798713 #yiv5724798713ygrp-text tt {
font-size:120%;}

#yiv5724798713 #yiv5724798713ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv5724798713

__._,_.___
Posted by: Mark Bacheldor <m_bacheldor@yahoo.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (7)
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

----------------------------------

.

__,_._,___
Diposting oleh EXCEL FEED LEARNING di 05.32

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)