Run UserForm When Linked Cell Is Empty

[pwebley]

I have a userform that appears as soon as my workbook is open and it requires that you enter your first and last name. It then dumps the name into a linked cell. I need help making that userform reappear if the contents of the linked cell are deleted or if it is empty. Any help will be appreciated.

 

[rs2k]

"Is this code supposed to be in Module1 of the workbook?"

Right Click the worksheet>View Code and paste it in there.

P.S. Andrew's code worked for me, otherwise try it in a new workbook and see if it works there.

 

[pwebley]

I have no doubt that you are right, I must be doing something wrong. I copied and pasted your code into my Module1 and received the same msgbox asking for a macro name to run. This should run my userform1 if the contents of cell C2 are removed or the cell is empty correct? If so thank you for your help. I will continue to run through trial and error. This has helped me though.

 

[pwebley]

Please disregard the images, that was by mistake.

 

[pwebley]

Every thing works great, thank you all for your help!!

 

[pwebley]

Every thing works great, thank you all for your help!! Sorry for being such a bother!!