Programming a confirm overwrite message box

Hello all,

This is my first post and I apologise if it's in the wrong place.

I have created a user form that allows various choices to be checked, which are then put into a cell in the spreadsheet.

However, I want a 'confirm overwrite? (yes/no)' message to be displayed if there is data already in the cell - clicking yes proceeds to overwrite and clicking no aborts the overwrite procedure.

Here is the code I already have, which is assigned to the OK box:

Please Login or Register  to view this content.

Any help is much appreciated.

Hi Duality, welcome to the forum.

Hopefully the following updated code does what you're seeking:

Please Login or Register  to view this content.