Input box - cancel button

Hello All,

I need some help writing a few lines that exits the sub if the users clicks the cancel button...........tried and am failing miserably!

Please Login or Register  to view this content.

Try changing the variable s_row to String, then add one line of code as shown below:

Please Login or Register  to view this content.

You may also want to add a check to confirm the string entered is a valid number (when converted from string to number), otherwise the remaining code may fail.

That worked perfect! I agree with you about validating the other data. The user needs to select data within a specified table, how could I achieve that?

Something like this will check a range of cells to see if the value exists. If it does, you can proceed with your code in the Else portion of the IF statement.

Please Login or Register  to view this content.