Maybe this helps you? Not sure if thats exactly what you mean, since it restrict the program to only allow numbers. I can't even be called a beginner in vba, but I do have quite some experience with c++. I'm sure that you'll manage to Change the If Not Statement accordingly

http://stackoverflow.com/questions/2...ll-input-value