I have an input box and wanted user just to input 7 digital data. However, I am afraid user may enter string data. Is there any way to check and ensure user can only input 7 digital data to that input box? Thanks a lot!!
if not isnumeric(controlname) then
msgbox "please enter a number"
cancel = true
exit sub
end if
if not len(controlname) = 7 then
msgbox "entry must be 7 characters in length"
cancel = true
exit sub
end if