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.
1) Right click the sheet tab and select VIEW CODE to open the sheet's code module in VBA
2) Paste in these event macros:
3) Close the vbeditor, make changes to cell D10
Please Login or Register to view this content.
Last edited by JBeaucaire; 05-07-2014 at 08:51 PM. Reason: Correction in red.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thank you JB. It worked! Much appreciated!!!
Correction in red above.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks