Dear all,
I have a checkbox and some 50 sheets.
I want some code to be executed if its checked. Below are the details;
1) If the checkbox is checked(value=ture)
-Run a code
What code has to do?
a) Ask user to key-in the sheet number(Inputbox)
b) Check if the user has keyed in 'Blank' or 'Non-Integer' value
1) If true: Then,
-Display a msg box accordingly
-Un-Check the checkbox (value=false)
-Exit the sub directly
c) Check it the user has pressed 'Cancel' button
1) If true: Then,
-Display a msg box accordingly
-Un-Check the checkbox (value=false)
-Exit the sub directly
d) If b) and c) are false, then go ahead the select the sheet using the number keyed-in by the user.

PS: I have sheets as "Sheets1,sheet2,sheet 3....

Plz help me out
Thanks.