New to VBA, need to do Vlookup after a value is entered

I have a couple VBA questions as this is my first time taking on a project involving VBA.

What I want to happen:
1. The user presses the button and an inputBox appears asking to input an auction number and an auction seller. These values are stored under variables AuctionNum and AuctionSeller.
2. Today's date is updated to the current date once the button is pressed and is stored in the variable TodayDate. This value is placed in the format mm/dd/yy in cell H2.
3. Vlookup formulas search through the database tab in cells B3:F30 to return the auction date in cell c7 and the total cars in cell c9. These values are stored in the variable AuctionDate and TotalCars.



The code I have been working on is currently under module 1 and i apologize if the formatting or anything is wrong. This is my first crack at something like this and am trying to learn.

I hope this makes sense and will try to answer any questions promptly.

Thank you,

Matt

**I'm using excel 2016 for Mac