macro to prevent double record data

There no "basic" command because there is more than one way to go about it.

Here are some suggestions:

1. Use the FIND method to search the target sheet, passing the relevant search criteria from the form to the

2. Declare a variable (Long type) and use the WorksheetFunction.Countif in VBA code, again, passing the relevant criteria from the form to the COUNTIF function

So if you user form contained a text box and want to test if the entry exist in sheet1 you might have code similar to this (written on the fly in this reply and not test - give as an example only).

Please Login or Register  to view this content.

"c" is a variable declared as Range type. We could have "rCell" or "rngCell" or "rFound" - any name we want for the variable.

It is used with the Find Method to establish the cell as a range object, assuming the value that is searched for is found on the worksheet.

HI oxxy and welcome to the Forum!!

Regarding this

I can't upload my worksheet because it too large to upload...

Zip the File then try the Upload...

HI oxxy

I'd suggest there's a problem with your file...there's no way it should be that large...un-zipped...33,000 plus KB...don't see it...