Can VBA to check all the charaters including symbols if it matches range("A1").character.

[pedie]

Hi,

Can VBA to check all the charaters including symbols to see if it matches range("A1").character/symbol.

Suppose i have "?" in A1, can i make the vba to try entering all the characters or symbols available in B1 and then see which one matches A1???

Or do i have to list symbols, characters available in one column and make it guess by trying different values in b1???


Thanks for helping!
Pedie

 

[pedie]

B.u.m.p!

 

[meldoc]

Good morning Pedie.

Do you mean this.

Excel Workbook
	A	B	C
1	?	aZBb/?zZ	Yes
Sheet1

Excel 2010<font face=Courier New><SPAN style="color:#00007F">Sub</SPAN> test()<br>    Range("C1") = Clear<br>  <SPAN style="color:#00007F">If</SPAN> InStr(Range("B1"), Range("A1"))<SPAN style="color:#00007F">Then</SPAN><br>    Range("C1") = "Yes"<br>  <SPAN style="color:#00007F">Else</SPAN><br>    Range("C1") = "No"<br>  <SPAN style="color:#00007F">End</SPAN><SPAN style="color:#00007F">If</SPAN><br><SPAN style="color:#00007F">End</SPAN><SPAN style="color:#00007F">Sub</SPAN><br><br><SPAN style="color:#007F00">' Or This</SPAN><br><SPAN style="color:#00007F">Sub</SPAN> test2()<br>  Range("C1") = Clear<br>    Ans = IIf(InStr(Range("B1"), Range("A1")), "Yes", "No")<br>  Range("C1") = Ans<br><SPAN style="color:#00007F">End</SPAN><SPAN style="color:#00007F">Sub</SPAN><br></FONT>

 

[pedie]

Brian, thank you so much. Sorry couldnt check back yesterday....was late so went to sleep...
I'm giving it a try

 

[pedie]

Brian, thanks & see you around!

 

[HalfAce]

Hi Pedie,
You could do this with a formula too if you wanted...

=IF(ISERROR(FIND(A1,B1)),"Nope","Yes")

Hope it helps.

 

[pedie]

Dan, thanks! I thought you're not here today

 

[HalfAce]

Oh, I'm here.
I just don't make much of an impression...

(Cute pooch)

 

[pedie]

Oh, I'm here.
I just don't make much of an impression...

(Cute pooch)