Select just one cell using input box
Posted on 2014-03-22
I would like to run the following macro
An inputbox should prompt the user to ...
... just select (1) one cell
... the selected cell is to conform to the following cell format '##-###-##-##', the pound sign standing for numbers, e.g. 55-443-22-99
... if one or both of the requirements is false the macro is to say so and to exit
... if both requirements are true the macro is to select the 'second' cell in that column. For example: the user selects 'C7', the macro is to move (offset) this selection to 'C2'
Help is much appreciated. Thank you very much in advance for your valuable help.