+ Reply to Thread
Results 1 to 2 of 2

Macro does not work in Userform

  1. #1
    Registered User
    Join Date
    07-01-2015
    Location
    United States
    MS-Off Ver
    Microsoft office standard 2007
    Posts
    52

    Macro does not work in Userform

    I have created a Macro which pulls excel files from a folder and pastes them into a Sheet in my workbook.
    I then created a user form which runs this macro.

    The Userform works perfectly on my computer.

    I then shared the excel file with other people to use.

    I changed the folder path for their specific computer.

    I run the macro without the user form and it works great.

    BUT

    When i run the macro through the userform it is not working Properly.

    He is the code, and thanks in advance!!

    Please Login or Register  to view this content.
    Last edited by jeck876; 03-21-2016 at 03:57 PM. Reason: SOLVED

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Macro does not work in Userform

    Hi jeck,

    Without a full study of your code this sounds like a Scope problem. See if cpearson can explain it better at:

    http://www.cpearson.com/excel/Scope.aspx
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ 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. need help with userform which does not work
    By Pilot5000 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-09-2015, 09:38 AM
  2. Userform Work with Two sheets
    By god_karthi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-27-2015, 10:05 AM
  3. [SOLVED] Macro work in personal workbook, doesn't work in other workbooks
    By Centexcel in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-30-2013, 11:47 AM
  4. [SOLVED] Macro Doesn't Work Through Button, Does Work Through Developer ->Macros Option
    By freybe06 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-27-2013, 11:55 AM
  5. Macro to collate data from different work books and different work sheets
    By bvdileep in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-04-2012, 05:34 AM
  6. Macro to change UserForm Label does not work?
    By Winon in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-24-2012, 06:39 PM
  7. Replies: 2
    Last Post: 07-11-2006, 11:15 PM

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