Avatar of Jacque de Lacy
Jacque de Lacy
 asked on

Migrating VBA code to an Excel workbook, require some help troubleshooting

Hi,

An expert on EE has kindly prepared some code for me, however, I am trying to migrate it to a new workbook however it appears as though I haven't replicated it properly.

Would an expert kindly aid me to see what I've done wrong?

The VBA codes are located in:
a) Sheet 1: Private Sub Worksheet_Change(ByVal Target As Range)
b) Sheet 13: Private Sub Worksheet_Change(ByVal Target As Range)
c) Module 4: Sub FindSaleID()

Essentially the code works by a user selecting a 'Sale_No.' from the dropdown list in cell F2 of Worksheet 'eBay_Template ('eBay_T')', alongwith a 'Duration of Sale' in cell J3 and entering a 'Price' in K3.

By clicking on the Check Box, a 'Yes' or 'No' is recorded against the corresponding Sale_No. in Column N of Worksheet 'New_Inventory ('New_I')'.

The date and time is recorded in Column O each time Column N is updated.

Column P shows how many days have expired since Column O was last updated, and is updated daily.

Column Q shows the 'Duration of Sale' from cell J3 of Worksheet 'eBay_Template ('eBay_T')'.

Column R shows the difference between Column Q - Column P

Column S shows the 'Price' from cell K3 of Worksheet 'eBay_Template ('eBay_T')'

Kind Regards
Jacque
Auction-Catalogues-Inventory.xlsm
Microsoft ExcelVisual Basic ClassicMicrosoft ApplicationsMicrosoft OfficeMicrosoft Access

Avatar of undefined
Last Comment
Martin Liss

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Subodh Tiwari (Neeraj)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Jacque de Lacy

ASKER
Hi,

It worked! Thanks.

I would like some adaptations to the code, can I ask them here or open a new question?

Regards
Jacque
Subodh Tiwari (Neeraj)

It would be better if you open a new question with your new requirement.
Martin Liss

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23