+ Reply to Thread
Results 1 to 3 of 3

Userform Activate Label in correct format

  1. 11-19-2009, 12:53 PM #1
    adam2308
    adam2308 is offline
    Forum Contributor
    Join Date
    02-20-2009
    Location
    Manchester, England
    MS-Off Ver
    Excel 2007
    Posts
    467

    Userform Activate Label in correct format

    I have the following code in a userform activate

    Please Login or Register  to view this content.
    What i want is the format of the label to display in the format "?/???" from the value in cell C2.

    What do i change to my line of code?

    Thanks.
    Last edited by adam2308; 11-26-2009 at 06:17 AM.
    Reply With QuoteRegister To Reply
  2. 11-19-2009, 01:01 PM #2
    Andy Pope
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Userform Activate Label in correct format

    If the cell has that custom format then use the .Text property instead of value.

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info
    Reply With QuoteRegister To Reply
  3. 11-19-2009, 01:34 PM #3
    adam2308
    adam2308 is offline
    Forum Contributor
    Join Date
    02-20-2009
    Location
    Manchester, England
    MS-Off Ver
    Excel 2007
    Posts
    467

    Re: Userform Activate Label in correct format

    That's great. Thanks Andy.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1