Userform Textbox Replacing String

[calvinle]

Hi,

I would like to know how to be able to replace a string after leaving the TextBox?
Becuz I am working on address and after paste the adress from CanadaPost,
If the box contain "é", it will be replace by "e". If "Ç" will replace by "C".

Please help.

[ajryan88]

Hi,

I have attached an example of what I think you're trying to achieve. The address will be entered into cell A1, just for demonstrative purposes. The important piece of code is the following:

Please Login or Register  to view this content.

As you can see, I have set up a case for each special character that needs to be replaced. If there are more characters that you need to potentially be replaced, then you could always add another case in before the Case Else statement. You can obtain the necessary character codes from this website (amongst many): http://www.gtwiki.org/mwiki/?title=VB_Chr_Values

I hope this helps

[Tinbendr]

Here is an article describing this. While the article describes restricting the textbox to numbers, it is easily adaptable to your requirements.

Here is an example of restricting to only the alphabet.

Please Login or Register  to view this content.

[calvinle]

Here is an article describing this. While the article describes restricting the textbox to numbers, it is easily adaptable to your requirements.

Here is an example of restricting to only the alphabet.

Please Login or Register  to view this content.

This only work on keypress. Because the address is copied from Canadapost, so it's a Copy and paste. I have try to use the AfterUpdate, but it doesnt work.

[Tinbendr]

replace a string after leaving the TextBox?

Ack! Misread this.

You could also use Ajryan88's code in the textbox exit event.

[calvinle]

I tried also but it doesnt work:

Please Login or Register  to view this content.

[Tinbendr]

How about this then?

Please Login or Register  to view this content.

Or maybe this

Please Login or Register  to view this content.

[calvinle]

First one work awesome.