Adding a Date/Time when using a LOOP to Save a New Entry

[sorensjp]

Hi All,

I'm hoping to add a time stamp to new Product Entry when it is saved on the PRODUCT_CONTROL Sheet. I want it to be placed in column E on the PRODUCT_DB Sheet once I run the Mac Below.

The Sub Product_SaveNew() code below is from the Attached Book.

The PRODUCT_CONTROL Sheet is the Back-end where I'm Adding and Saving any new products.
The PRODUCT_BROWSER Sheet is a Front-End where a customer may view products available for sale.
I welcome any advice on this project and am very much still learning.

Please Login or Register  to view this content.

Be Safe, and Thank you,
V/r,
Jim

ADDED

I realized I did have an error with the code above - whereas "For VendorCol" should be "For ProductCol"

Also I have some code that does use the InStr Function w/in the For Loop and was thinking I could use it but don't know how to adjust it.

Please Login or Register  to view this content.

Again Thank you for looking,
V/r,
Jim

[sorensjp]

Hello,

I figured out how to add the Date in the by simply adding:

Please Login or Register  to view this content.

to the Product_SaveNew Sub

I appreciate everyone looking and spending time reading.

V/r,
Jim