+ Reply to Thread
Results 1 to 3 of 3

Using a button to pull data from another worksheet

  1. #1
    Registered User
    Join Date
    01-27-2012
    Location
    texas
    MS-Off Ver
    Excel 2007
    Posts
    2

    Unhappy Using a button to pull data from another worksheet

    Hi, I am brand new with VB, so I am completely lost with this.

    My workbook contains a report, that consists of two pages: a Data sheet and a Pulse sheet. I am trying to add a button that, when clicked, fetches information from the Pulse sheet and plugs it into the data sheet. The trick is that the data is pulled and copied to multiple lines and columns. I found this code on a forum, so decided to try it:

    Please Login or Register  to view this content.
    When I hit the button, it gives me a run-time error '438' - Object doesn't support this property or method and it highlights the red text above (Selection.OnAction = "Button1_Click")

    Any help? I can give more info, just let me know what you need. Thank you!!
    Last edited by btrfly701; 01-27-2012 at 10:59 AM.

  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: Using a button to pull data from another worksheet

    Can you post a workbook?

  3. #3
    Registered User
    Join Date
    01-27-2012
    Location
    texas
    MS-Off Ver
    Excel 2007
    Posts
    2

    Thumbs up Re: Using a button to pull data from another worksheet

    Unfortunately I cannot, due to confidential material.

    But - good news - I just deleted the line I was having problems with, and it seems to be working fine now! This is what I have now (i changed the names of the sheets to current month and pulse - current month):

    Please Login or Register  to view this content.
    Thank you for your offer to help, but I think it is good now. If you see any issues that I'm missing, feel free to advise.

+ 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