mathsguy2011
04-06-2011, 09:36 AM
hi, i have a userform with 6 textboxes. in each textbox i want the user to input a decimal number between 0 and 1 and i then want to check before continuing program that this is what they have done. i read in the textbox value using code eg. r1=val(textbox1)
i then want to check that r1 is between 0 and 1 which i can do but also check that it is only upto4 decimal places how do i do that?
i then want to check that r1 is between 0 and 1 which i can do but also check that it is only upto4 decimal places how do i do that?