Results 1 to 15 of 15

Macro to paste value from userform label

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-16-2004
    Posts
    125

    Macro to paste value from userform label

    Hi and thanks for any help.

    I have a userform with a Label called Label1. This label contains a time value formatted like this (00:00:00.00) I need a macro that takes certain portions of this time value (hours, minutes, seconds, etc) and puts the value in a specific cell. I'm not sure how to do this. I have successfully been able to put the whole value in a cell, but I need to be able to separate this by putting the hours, minutes, and seconds in different cells. Here is the code I currently have.

    Range("J7").Value = Label1
    What I want to do is put the hours in J7, the minutes in K7 and the seconds in L7. I know this is probably really simple, but I'm not very experienced with VBE.

    Thanks for any help.
    Last edited by CJ-22; 06-20-2013 at 02:25 PM.

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