Cell Input checker

[stevewilde]

Is there a code that I could use to check that information has been inputted by the user in to a cell. E.g. Check that A1 the user has entered their name, before the rest of the macro that I have written will run. If they haven't a message box will appear to tell them what is wrong and then select cell A1 for them to input the necessary information.

Thanks

[DonkeyOte]

In basis terms - along the lines of:

Please Login or Register  to view this content.

[stevewilde]

Thanks for the reply. The code did work but once I clicked ok on the message box, the rest of my code ran anyway - is there a way to terminate the macro until A1 is filled in??

Thanks

[DonkeyOte]

Oh dear - what is wrong with me today ??

I forgot THE main line of code:

Please Login or Register  to view this content.

[stevewilde]

All sorted - thanks ever so much for the help!!

[Jack in the UK]

Get it right ah

Your need to edit this a bit -- try and test see what you think

Please Login or Register  to view this content.

[stevewilde]

Thanks for this alternative