View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default more VBA code help...please!

It kind of sounds like you could use that same code that checks before it
copies.

But this time, if you don't see a match, you issue the warning (instead of
warning if you do find a match).

Anthony wrote:

Hi again,

when the user exits my workbook I want some code to check and see if the
data on the worksheet (data entered in range A7:O100) has already been added
to the 'database' (a worksheet named database). If it hasn't then add aLL the
data then show a msg box stating
-data copied to database please save and close programe again-
If it has then close save and close the programme

any help apreciated
many thanks


--

Dave Peterson