As the title says I've been trying to make it so that a textbox on a userform can only have numbers entered into it with an error message popping up if letters are added.
The code I've used before doesn't seem to be working and I can't figure out why:
Any ideas on a fix or what is going wrong?
Please Login or Register to view this content.
Hi Mousiefuzz,
My speculation is that you added a frame around the TextBox, and now the Frame is the Active Control.
The following code seemed to work for me with your file:
LewisPlease Login or Register to view this content.
Hi, Mousiefuzz,
have a look at the KeyPress-Event behind the textbox to limit what may be entered:
Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Sorry for the slow reply and thank you very much for your quick answers! Unfortunately I'd left my work PC for the day when they came in but tried them out first thing this morning and both solutions work great! I honestly never knew that frames affected the code so much, guess I need to look a little more in to what they do.
But thank you both so much for your answers, as I said, both of them worked and solved my problem perfectly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks