Hello all,

First post and quite new to VBA and macro's in Excel.

I have a validated list drop box in cell D10. It defaults to a blank, because this cell will not be necessary for all users.

When an option is chosen from the list, I need the user to input a single number of hours scheduled for the task they choose and paste that number to cell AA1.

I also need to clear cell AA1 if the drop down list cell, D10, is cleared.

Really appreciate any help available.