danuk1976

Board Regular
Joined
Nov 17, 2013
Messages
56
Hi all

Does anybody know the symbol for space when doing a like or am I missing something

this does not work
Code:
If Me.TextBox5.Text Like "*At At*" Then        
Me.TextBox5.ForeColor = vbRed
        Else
        Me.TextBox5.ForeColor = vbBlack
    End If


I also have this below looking for a match with ' character (eg brian's)

it works good, so need the character code for a space
Code:
If Me.TextBox5.Text Like "*ƒ??*" Then       
Me.TextBox5.ForeColor = vbRed
        Else
        Me.TextBox5.ForeColor = vbBlack
    End If
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
Does anybody know the symbol for space when doing a like or am I missing something

this does not work
Code:
If Me.TextBox5.Text Like "*At At*" Then        
...
...
There is not special character for a space... a space is a space. As written, your If..Then line of code above is checking TextBox5 for any number of unspecified characters followed by an uppercase "A" followed by a lowercase "t" followed by a (normal) space character followed by an uppercase "A" followed by a lowercase "t" followed by any number of unspecified characters. Notice the uppercase and lowercase as that is important... if either of those A's are lowercase, or either of those t's are uppercase, the test will fail. Also, if TextBox5 contains two spaces between the two "At" text, the test will also fail.



I also have this below looking for a match with ' character (eg brian's)

it works good, so need the character code for a space
Code:
If Me.TextBox5.Text Like "*ƒ??*" Then       
...
...
Just pointing out that the above If..Then test is not testing for an apostrophe (') at all... those question marks will allow any characters to exist at the two characters after the lowercase "f". If you want to test for an apostrophe directly, then put an apostrophe in at that location.
 
Upvote 0
thank you kind sir, running this vba in publisher but don't think that should make a difference

I will try this again over the weekend and give some feedback on where I am going wrong
 
Upvote 0
okay schoolboy error, i was running 2 instances as below so yes "At At" was coloured red but if "As As" was false it quickly coloured black

Code:
[COLOR=#574123]If Me.TextBox5.Text Like "*At At*" Then        
[/COLOR]Me.TextBox5.ForeColor = vbRed
Else
Me.TextBox5.ForeColor = vbBlack [COLOR=#574123]    
End If[/COLOR]

[COLOR=#574123]If Me.TextBox5.Text Like "*As As*" Then        
[/COLOR]Me.TextBox5.ForeColor = vbRed
Else
Me.TextBox5.ForeColor = vbBlack 
[FONT=Verdana]End If[/FONT]  [COLOR=#574123]
[/COLOR]

thanks again for confirmation rick
 
Upvote 0

Forum statistics

Threads
1,213,522
Messages
6,114,112
Members
448,549
Latest member
brianhfield

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top