Hi everyone,

I have a macro that creates a checkbox and some writing in a cell... pretty simple. But every time this macro is used the checkbox that is created is defaultly named "CheckBox 39", then next time "CheckBox 40", then "CheckBox 41" etc etc...

This means that the separate macro that I'm trying to write to delete the checkbox and writing that is made is puzzling me. I can't specify the checkbox name because it changes each time the macro is run, but similarly it doesn't recognise me changing the name to something else and then searching for the box named that.

Has anyone got any ideas of how I can basically highlight a checkbox that appears in a specific place on a worksheet, so can then simply delete it?!

A simple but bizare problem nonetheless!

Cheers guys,

Alex