You can't do that with justa chckbox. Once run the code will not recognise when a number is entered. Why not use a WorkSheet event instead of the checkboxes.