Results 1 to 4 of 4

Trying to Update Userform Label with worksheet cells

Threaded View

  1. #1
    Registered User
    Join Date
    06-22-2013
    Location
    John,Doe
    MS-Off Ver
    Excel 2011
    Posts
    7

    Trying to Update Userform Label with worksheet cells

    I am trying to copy the text I created in the worksheet cells to the Userform and have it automatically update every time to the cells text changes in the worksheet. I can get it to work if I use the click event but I want it to change automatically. Any suggestions would be appreciated! Thanks

    Private Sub Label1_Change()
    Label1 = Worksheets("Sheet1").Range("A2").Value
    End Sub
    Last edited by bmoon171; 06-22-2013 at 06:43 PM. Reason: Proper Code

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