How to validate multiple text in the TextBox control

Posted on 2011-03-11
Last Modified: 2012-06-21
Hi I need help with validation of multiple control words in the TextBox.
I have this simple code, which validates the user into the TextBox wrote:

If Slide5.TextBox4.Value = "Prague" Then
Slide5.TextBox4.BackColor = &HC0FFC0
Slide5.TextBox4.BackColor = &HC0C0FF
End If

I want the textbox the words "Prague" also recognized and inserted the word "Prag", ie. If the user writes, "Prague" or "Prag", then change the color: .BackColor = &HC0FFC0
Thanks in advance for your help.
Question by:Thomas_Meyer
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2

Accepted Solution

4runnerfun earned 300 total points
ID: 35111148
As in... ?
If Slide5.TextBox4.Value = "Prague" OR Slide5.TextBox4.Value = "Prag" Then
Slide5.TextBox4.BackColor = &HC0FFC0
Slide5.TextBox4.BackColor = &HC0C0FF
End If
LVL 59

Assisted Solution

by:Chris Bottomley
Chris Bottomley earned 200 total points
ID: 35111155
If Slide5.TextBox4.Value = "Prague" or Slide5.TextBox4.Value = "Prag"Then
Slide5.TextBox4.BackColor = &HC0FFC0
Slide5.TextBox4.BackColor = &HC0C0FF
End If
LVL 59

Expert Comment

by:Chris Bottomley
ID: 35111162
Snap ... ish!


Author Closing Comment

ID: 35111217
Thanks, it was so easy!

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

PowerPoint is the go-to presentation software for millions of users around the world. Many presentations use basic text features but you can really make special text jump out of your slide by applying this bubble text design process. This article ha…
Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question