+ Reply to Thread
Results 1 to 2 of 2

EDIT: SOLVED. Can't pass object to the sub

Hybrid View

  1. #1
    Registered User
    Join Date
    04-12-2020
    Location
    United States
    MS-Off Ver
    365 I think
    Posts
    15

    EDIT: SOLVED. Can't pass object to the sub

    In my class mod, I have a class mod called InputBox

    When I write the following in a workbook code window, and try to pass the object to the sub,

    Dim inputBox1 As New inputBox
    LoopthroughFilesAndForEach (controlFile, inputBox1)
    The LoopthroughFilesAndForEach gets highlighted in red and tells me "Expected: ="

    edit: nvm... i just needed to remove the parantheses.
    Last edited by Ariesthesheep; 07-07-2021 at 08:16 PM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,889

    Re: EDIT: SOLVED. Can't pass object to the sub

    To mark a post as SOLVED go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. pass name of object to sub
    By tim_p in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-05-2020, 07:47 AM
  2. Cannot pass object to sub-procedure located in worksheet?
    By Hicmade in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-21-2019, 06:19 AM
  3. [SOLVED] Pass dictionary keys into stack object vba
    By jaryszek in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 10-09-2017, 04:06 AM
  4. [SOLVED] Pass value of Object to String
    By Rick_Stanich in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-06-2012, 10:43 AM
  5. Pass Array to Range Object
    By Paluee in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-21-2010, 01:44 PM
  6. How to pass CommandButton object ?
    By dpenny in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-01-2007, 03:10 PM
  7. [SOLVED] Pass a form Listbox as an object
    By Brian in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-18-2005, 07:55 PM

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