+ Reply to Thread
Results 1 to 3 of 3

error VBA script trying to bring userform data from different then active sheet

  1. #1
    Registered User
    Join Date
    09-02-2012
    Location
    Bulgaria
    MS-Off Ver
    Excel 2010
    Posts
    19

    error VBA script trying to bring userform data from different then active sheet

    Hello ,

    i'm using the following script which i use in a userform, but i want to run it from different sheet but i cannot make it to work except the active sheet. Even when i set it up with specific sheet name it is not working when i try to run it from different sheet.
    when i use the debug it is saying the error text is in bold. Thanks for the help in advance.

    Please Login or Register  to view this content.
    Last edited by archangel9999; 09-02-2014 at 04:31 AM.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: error VBA script trying to bring userform data from different then active sheet

    Get rid of the Select/Selection.
    Please Login or Register  to view this content.
    PS Can you add code tags when posting code?
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    09-02-2012
    Location
    Bulgaria
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: error VBA script trying to bring userform data from different then active sheet

    Thank you very much for your reply it is working when i fix the little mistake here.
    Please Login or Register  to view this content.
    If it is possible i would like also to ask for your help to help me with this selection code also.

    Please Login or Register  to view this content.
    Thank you very much for your help in advance !

+ 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. Script not copying data from "Emails" sheet to "New Sheet" - Run time error: Object
    By methuselah90 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-08-2014, 03:22 PM
  2. How to bring second worksheets data in Userform ListBox2 ?
    By z-eighty2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-08-2014, 02:12 PM
  3. using ListFillRange on sharable sheet bring error message
    By thano in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-01-2007, 03:48 PM
  4. Replies: 0
    Last Post: 03-01-2006, 04:25 PM
  5. userform - active sheet
    By gillesdhooghe in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-20-2006, 08:30 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