+ Reply to Thread
Results 1 to 15 of 15

Macro to paste value from userform label

Hybrid View

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

    Re: Macro to paste value from userform label

    Hi Mordred,

    I'm sorry for all the confusion, but I really could use your help. I have reread my posts and realize how confusing they were. My first question was to only get the values from the label in the right cell. I wanted the hours in one cell, the minutes in the next cell, and the seconds and decimals together in the next cell. Your code worked great as long as the value in the label was more than 00:01:00.00 (one minute). If it was less than one minute the seconds and decimal values were placed in different cells. Once I knew how to get the values from the label in the right place I was going to use an If/Then arguement to place the values to the right, but your code anticipated this only down. If you or anyone is willing to help I would appreciate it.

    Thanks again.

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

    Re: Macro to paste value from userform label

    I wanted to thank everyone who offered help. When this thread died out I posted on a different forum and found an answer. Here is a link for anyone who might be interested.

    http://www.ozgrid.com/forum/showthread.php?t=179744

    Thanks again for all your time.

+ 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