+ Reply to Thread
Results 1 to 2 of 2

Userform Label to equal cell value

Hybrid View

PDBartlett Userform Label to equal cell... 08-13-2014, 04:16 AM
PDBartlett Re: Userform Label to equal... 08-13-2014, 04:39 AM
  1. #1
    Forum Contributor
    Join Date
    04-04-2014
    Location
    Tetbury, England
    MS-Off Ver
    Excel 2010
    Posts
    254

    Userform Label to equal cell value

    Hello

    I'm trying to make my labels equal a cell value. The cell value can change so I can't have the label caption fixed.

    Here's what I have and it's not working:

    Private Sub frmPL_Input_Initialize()
        Me.Label21.Value = Sheets("MASTER").Range("A17").Value
    End Sub

  2. #2
    Forum Contributor
    Join Date
    04-04-2014
    Location
    Tetbury, England
    MS-Off Ver
    Excel 2010
    Posts
    254

    Re: Userform Label to equal cell value

    Saw another thread - solved


+ 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 Label that equals cell value
    By shawnvon in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-10-2014, 07:12 PM
  2. [SOLVED] Label Caption = cell value In UserForm
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-18-2014, 08:37 AM
  3. cant get userform label to display cell value
    By justaguyfromky in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-02-2011, 01:11 PM
  4. Display Cell Value on UserForm Label
    By Burke in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-20-2008, 06:59 PM
  5. [SOLVED] Displaying Cell Value in UserForm Label
    By Frank & Pam Hayes in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-07-2005, 06:05 AM

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