Force only numeric to text box not working

Hi,

I´m trying to force only to allow numeric values to 3 text boxes. The below code is what I can come up with so far by searching the net, but it will not work. Basically it does nothing and if I try to play around with it and change it in any way I just get errors.

Maybe some VBA genius is able to see what might be the problem in this:

Please Login or Register  to view this content.

Hi RudiS,

It Works indeed in your example file, but for some reason it does not do anything in mine.

I have no Clue what could be the problem. If i just make a MsgBox upon change of the textbox it Works meaning I´m putting the code in the right Place, but the OnlyNumbers will not kick in if I type letters.

Can you look at my example here and see if you see the problem?

Example Not Working.xlsm

P.S. Upon atrt hit the "Legg til Avtale" button, then Select the optionbutton up in th eright corner "Leasing". Then the textbox "Avtalenummer" is enabled which is the texbox in question.
By the way, I also tried the onlynumbers on several other texboxes but nothing.

RudiS and mikerickson,

both solutions work. Thank you so much

So stupid of me that I didn´t see that it was in a frame. Sometimes you just get completely blinded for the easiest things.

Will mark this as solved!