
Image 1
This is great for when you need to compare string values, from perhaps user generated infomation. For this example I have taken it from a user log in screen. I always forget whether a username or password is case sensative, and more importantly, did I use capitilisation anywhere within the user or password details…? A very easy way to solve this problem is when the user logs in capture their log in and password and convert it it to a lowercase string for comparison against the saved log in info for that user. You may be thinking why do this, well in Excel strings “Password” would be read completely different to “password”.
In this example I use the variables called LogInUsername & LogInPassword to capture the information the user enters into the log in box and password box respectively. I then convert this to lowercase using the the StrConv function in Excel VBA. The code below is missing alot of other information that is irrelevent for this example.
LogInUsername = LogIn.LogInUsername.Value 'Captures log in name
LogInPassword = LogIn.LogInPassword.Value 'Captures password
If StrConv(Cells(X, 1), vbLowerCase) = LogInUsername And StrConv(Cells(X, 2),vbLowerCase) = LogInPassword Then
Call NextStage
Unload Me
Exit Sub
End If
Unload Me
End Sub
The line of code in green is the part that converts the saved log in and password information for that user to lowercase. So, StrConv(Cells(X, 1), vbLowerCase) = LogInUsername
takes goes to the cell, in this instance X,1 and converts the username saved there to lowercase to then compare against the username the user has enterered to log in. The same goes for the password section as well – StrConv(Cells(X, 2),vbLowerCase) = LogInPassword
This ensures that no matter where a user uses capitilsation I can ensure that it won’t cause problems with logging in. So “Password” would read the same as “PASSWORD” and “PaSsWoRd”. This line of code can be modified as well, simply replace the vbLowerCase with vbProperCase and it will capitilise the first letter of every word for you.
Ponto IPTV a melhor programacao de canais IPTV do Brasil, filmes, series, futebol, lutas, shows, documentarios em alta definicao de imagem e som em SD, HD, FULL HD, 4K. compativel com todos aparelhos do mercado Brasileiro.
Now I am ready to do my breakfast, once having my breakfast coming yet again to read other news. Look at my blog post; billigste ipad
Ponto IPTV a melhor programacao de canais IPTV do Brasil, filmes, series, futebol, lutas, shows, documentarios em alta definicao de imagem e som em SD, HD, FULL HD, 4K. compativel com todos aparelhos do mercado Brasileiro.
Sweet blog! I found it while browsing on Yahoo News. Do you have any suggestions on how to get listed in Yahoo News? I ave been trying for a while but I never seem to get there! Many thanks
I think this is a real great blog post.Really thank you!
There is perceptibly a lot to identify about this. I suppose you made some good points in features also.
Replica rolex watch delicious beauty and trendy rrnner ultimate synthesis.
Very nice post i must say wedkarstwo.Very nice post i must say wedkarstwo.Very nice post i must say wedkarstwo.Very nice post i must say wedkarstwo.Very nice post i must say wedkarstwo.
Thank you ever so for you blog article.Thanks Again. Great.
We are a group of volunteers and opening a new scheme in our community. Your website provided us with valuable info to work on. You’ve done an impressive job and our entire community will be thankful to you.
It as hard to come by knowledgeable people in this particular subject, but you sound like you know what you are talking about! Thanks
Your personal stuffs outstanding. At all times
I saw two other comparable posts although yours was the most beneficial so a lot
This genuinely answered my predicament, thank you!
This blog site is pretty cool. How can I make one like this ? How To Donate A Car For Tax Deduction
Well I truly liked studying it. This post procured by you is very constructive for correct planning.
Simply wish to say your article is as astonishing. The clarity in your post is simply great, and I could assume you are an expert on this subject. Well with your permission let me grab your RSS feed to keep updated with forthcoming post. Thanks a million and please keep up the gratifying work.
Some genuinely choice blog posts on this website , bookmarked.
You are my function models. Many thanks for your post
Well I truly liked reading it. This post offered by you is very constructive for proper planning.
Major thankies for the blog article. Really Great.
Yay google is my king assisted me to find this great site!. Don at rule out working with your hands. It does not preclude using your head. by Andy Rooney.
Very good blog.Much thanks again. Want more.
Looking around While I was surfing yesterday I saw a excellent article about
Thanks again for the blog post.Much thanks again. Great.
This blog is definitely awesome additionally informative. I have chosen a lot of useful tips out of this amazing blog. I ad love to come back over and over again. Thanks!
Thankyou for helping out, great info.
Usually I do not read article on blogs, but I would like to say that this write-up very pressured me to take a look at and do so! Your writing taste has been surprised me. Thanks, quite great article.
Really enjoyed this blog article.Really thank you! Cool.
Loving the info on this internet website , you might have done great job on the blog posts.
Wow, wonderful weblog structure! How long have you ever been blogging for? you make blogging look easy. The full look of your website is excellent, as well as the content!
Substance Abuse Organizations Outpatient Drug Rehab ÿþ< Private Alcohol Rehab Free Drug Rehab Programs
ÿþh
we like to honor lots of other net web sites around the web, even if they aren
There is noticeably a lot to realize about this. I suppose you made certain nice points in features also.
Really enjoyed this article.Really looking forward to read more. Fantastic.
wonderful issues altogether, you simply gained a emblem new reader. What may you recommend in regards to your put up that you just made a few days ago? Any positive?