I'm struggling to create a validation check on visual basic. I am currently using an input form on VB which copies the information entered on the form onto a cell on a sheet on Excel.
I have 2 areas where a number is typed, in both are textboxes. I need to have a validation check to check the range (0-50) and to check the value entered is a number and is an integer.
I cannot use the validation checks used on cells in Excel as I am using an input form on VB.
I have 2 areas where a number is typed, in both are textboxes. I need to have a validation check to check the range (0-50) and to check the value entered is a number and is an integer.
I cannot use the validation checks used on cells in Excel as I am using an input form on VB.