+ Reply to Thread
Results 1 to 1 of 1

Userform linking with active worksheet not maintaining link with correct worksheet

  1. #1
    Registered User
    Join Date
    10-04-2012
    Location
    yorktown va
    MS-Off Ver
    excel 2007
    Posts
    7

    Userform linking with active worksheet not maintaining link with correct worksheet

    Hi Everyone

    Thanks for reading this post

    I have developed a Userform that works great as long as I don't change active worksheets. When I do, the userform tries to link with the current worksheet instead of the worksheet containing the data. I'd like to see the changes in real time as I make adjustments using the userform. My userform works once, if I start it in the data worksheet and move to the second. But as soon as I try to use the userform again, it tries to pull data from the active sheet. If I try opening the userform using a command button on the second sheet it opens but again tries pulling the data from the active sheet.

    I'm at my wits end, any help will be greatly appreciated

    I've attached me file

    Thanks again
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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