+ Reply to Thread
Results 1 to 4 of 4

Weird Error!! Can someone help please

  1. #1
    Registered User
    Join Date
    02-12-2006
    Posts
    54

    Weird Error!! Can someone help please

    Hello

    I have this following function in a module called (MyFunctions):

    Please Login or Register  to view this content.
    So, When I call this function (AddPlayer) from within the subroutine Workbook_Open() then it works just fine, however when I call it from MyFormButton_OnClick() subroutine then it gives me the error message that you can find attached in this post as an image format. So, when I hit the debug button it hightlights and takes me to the following line of this (AddPlayer) function:

    Please Login or Register  to view this content.
    I don't get it, what's wrong here?

    Note: The (GetGroups) in that line of code above is a function that gets the available groups names that are to be selected from for each player name.
    Attached Images Attached Images

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    My assumption is similar to yours ...
    It must be related to the function GetGroups ...

    Difficult to guess ..., may be

    make it Public, if it is Private ...

    HTH
    Carim

  3. #3
    Registered User
    Join Date
    02-12-2006
    Posts
    54
    It is public already!! This is really weird, I just don't know why the object disconnects from the caller at that line

  4. #4
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Quote Originally Posted by cgi_pro
    It is public already!! This is really weird, I just don't know why the object disconnects from the caller at that line
    Hi,

    That it works in one area (Workbook Open) but not later from Forms, and given that Validate List is a 'single-sheet' function I would check the 'Active Sheet' at both times, but I will agree that the error doesn't really point to an error of this nature (but then - since when did VB errors seem logical)

    hth
    ---
    Si fractum non sit, noli id reficere.

+ 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