vba to only allow percentage format

Hi All,

Will be needing your help again.

I'm trying to place a restriction in my form, I want my form to only allow percent format "##.##%"

If users place a text "aaaaa" in that textbox a prompt will appear.

Here is my progress so far, but not working

Please Login or Register  to view this content.

Any help will do. Thanks!

Try this;

Please Login or Register  to view this content.

Please Login or Register  to view this content.

?

Originally Posted by jindon

Please Login or Register  to view this content.

?

Thanks Jindon, working!