Allowing only numbers and just1 letter in a cell

[machiax]

Hi all , New to VBA
I wish to allow only numbers and the letter "P" in a cell. and if that rule is not complied with, a message appears that says "please only use numbers or the letter P".

ty for help

 

[jasonb75]

You don't need vba for that, just simple data validation using a formula as a custom validation rule.

=AND(SEARCH("p",A1),--SUBSTITUTE(A1,"p","",1))

 

[machiax]

You don't need vba for that, just simple data validation using a formula as a custom validation rule.

=AND(SEARCH("p",A1),--SUBSTITUTE(A1,"p","",1))

i have to do it with macro, because this condition is part of biggest macro in a userform text box.

 

[jasonb75]

because this condition is part of biggest macro in a userform text box.

It would be a good idea to specify things like this in your question rather than adding them later. That way you might get what you actually need instead of the incorrect thing that you asked for.

 

[jasonb75]

I believe that the only way to do what you want is with a regular expression, however it is not something that I understand well enough to write the code that you need. It is possible that your thread will be viewed by another member who will be able to help you, although it is less likely with a thread that already has replies.