Results 1 to 8 of 8

ComboBox Time Value/Command button click update

Threaded View

  1. #1
    Registered User
    Join Date
    06-09-2011
    Location
    Denver
    MS-Off Ver
    Excel 2007
    Posts
    25

    ComboBox Time Value/Command button click update

    Attach workbook has a user form.

    I have it close to functioning the way I need it to.

    What I can't figure out is how to format the ComboBox to display the selected time (in minutes) and not a decimal value - if I select 00:01:00 it should stay 00:01:00.

    Second, I need the times (labels where time calculation is displayed) to update every time the command button is clicked from the values in the ComboBoxs.

    Also, it enters debug if the ComboBox times are selected first before clicking the command button, how can I get around this?

    Any help is appreciated!

    Thank you.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. use a command button to click other command buttons
    By fcharl9 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-20-2013, 08:48 PM
  2. Automatically update existing data using a Update command button
    By 9999335 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-23-2012, 09:46 PM
  3. UserForm, update after command button click
    By ker9 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-01-2010, 01:05 PM
  4. VBA Click Command Button
    By Benz in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-04-2006, 04:30 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