Selection Change working after second click on the cell. How to fix?

[80Wil]

Hi I have this code to format phone numbers. User types the whole number and when moves to another cell, the phone gets formatted.

Numbers can have 10 or 11 digits. If I type 10 digits and click outside the cell... it gets formatted correctly.

10 digitis 2233334444 > (22) 3333-4444

If I go back to the cell and type 11 digits the format does not change, only after clicking outside the cell and clicking on it again.

11 digits 22333334444 > (2) 233333-444 > click outside and click back corrects the format > (22) 33333-4444

What should I add to the macro to fix this issue? Thank you

Please Login or Register  to view this content.

[TMS]

Use the Worksheet Change Event handler, not the Worksheet Selection Change Event handler.

[TMS]

Please Login or Register  to view this content.

[80Wil]

Thank you! Worked!

A question (Maybe I should open a new thread let me know... ) ok the number is formatted (22) 3333-4444, but in the formula bar appears 2233334444.
This value will be sent to a table by VBA, how to send it formatted... something I can add to this macro I'm using to format it?

[TMS]

Use the Format function with the Custom Format strings that you already have. In other words, don't just format it, convert it to a text string.

[TMS]

You're welcome. Thanks for the rep.