VBA Userform - Restrict Text Box to integers between 18 - 80

[kamelkid2]

i am attempting to learn userforms for the first time to try and make things a little more presentable than having users fill out excel cells. in textbox "TextBoxAge", i am trying to restrict the user to inputting values between these values.

right now, i found this very useful code that only allows integers to be pressed

Please Login or Register  to view this content.

but it will obviously allow for an age of 10000.

can anybody point me in a direction to allow me to restrict the values so that if the age exceeds 80, it will beep?

im sure there is probably a better way (like a scroll bar maybe?), but like i said - this is my first project with userforms so please excuse my ignorance on the subject

[tehneXus]

try this: 18-80.xlsm