+ Reply to Thread
Results 1 to 1 of 1

Calculating/adding userform textbox values based on combobox selection and display to cell

  1. #1
    Registered User
    Join Date
    11-28-2014
    Location
    Melbourne, Australia
    MS-Off Ver
    2013
    Posts
    5

    Calculating/adding userform textbox values based on combobox selection and display to cell

    Hi there,
    I have another query, and after a day of trialling and searching for an answer, I hope someone here can help...

    In my workbook, I have a userform. Userform is a timesheet, and allows for 2 different 'activities' to be entered (if needed) per day. Each combobox will have 4-5options (all the same)

    I want to be able to select an option from the drop down box on any/all/some days, enter a number (hours) in the corresponding textbox, then calculate the total wage for each activity (there is also an 'hourly rate' textbox on userform) which will display on a worksheet summary page.

    I.e Monday ActivityOne ComboBox = "Growing" Hours = 2
    Tuesday Activitytwo combobox = Growing" Hours = 3
    Then in my worksheet cell, I want to sum up all the 'Growing' hours (in this case 5), and multiply that by the wage rate, and display the result in the worksheet cell.

    This is that portion of my code so far,
    It doesn't 'error', all it currently does is display a '0' on my worksheet.....

    Please Login or Register  to view this content.

    I will also try to upload the file to save any confusion. The code I am having issues with in the 'Timesheet' userform, under the 'record timesheet' command

    Thank you :-)
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Userform textbox value based on combobox selection
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-17-2014, 11:56 AM
  2. [SOLVED] Fill a cell via textbox on userform depending on combobox selection
    By Rhamilton2512 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-15-2012, 10:29 AM
  3. Textboxes within Userform to display info based on combobox selection
    By alter54 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-28-2012, 12:40 PM
  4. Assign values to textbox within userform based on combox selection.
    By alter54 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-16-2012, 03:55 PM
  5. Change Userform Textbox based on GUI Cell Selection
    By canyon289 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-09-2011, 06:21 PM

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