+ Reply to Thread
Results 1 to 3 of 3

Convert cell from months to hours (and vice versa) with ActiveX combobox

  1. #1
    Registered User
    Join Date
    05-16-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    3

    Convert cell from months to hours (and vice versa) with ActiveX combobox

    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!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor tehneXus's Avatar
    Join Date
    04-12-2013
    Location
    Hamburg, Germany
    MS-Off Ver
    Work: MS-Office 2010 32bit @ Win8 32bit / Home: MS-Office 2016 32bit @ Win10 64bit
    Posts
    944

    Re: Convert cell from months to hours (and vice versa) with ActiveX combobox

    Hi,

    check the code in the attached workbook: BudgetTemplate-HRLY-MTHLY-TEST.xlsm
    Please use [CODE]-TAGS
    When your problem is solved mark the thread SOLVED
    If an answer has helped you please click to give reputation
    Read the FORUM RULES

  3. #3
    Registered User
    Join Date
    05-16-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Convert cell from months to hours (and vice versa) with ActiveX combobox

    Thank you for your help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1