Hi,
I'm working on a creating a template for proposal budgets. Some people like to project labor using annual salaries and calendar months, and others like to use hours and hourly wages.
I have this workbook set up so they can use either method of entry. Ultimately, I need everything in units of calendar months, so what I am trying to do is if someone used hours as their entry unit, if I go back and change the dropdown back to "Months" then it would convert their hours (cells C5, E5, G5, I5, K5 in the attached xls) into months (by dividing by 160).
I'm guessing this can be done by writing a piece of code for the ActiveX combobox, but as a newbie to Excel programming, I don't know what that piece of code would be.
Can anyone assist me?
Thank you!
Bookmarks