Overwrite warning

[Andelousiano]

Hi,

I have some code in a form that finds the matching row based on a text box and copies the data to that particular row.

Here's the code:

Please Login or Register  to view this content.

This works great, but if there is already data in the particular row that it finds, it gets overwritten. Is there a way to have a warning pop up if any data is in the found row, so the user doesn't accidentally overwrite a row's data?

Thanks!!
Marc

[TMS]

Use Count, COUNTA, or CountIf to check the range before you overwrite it.

[sintek]

Have a look at this code from excel guru and adapt it to use

Please Login or Register  to view this content.

[sintek]

Perhaps like such...Untested

Please Login or Register  to view this content.