+ Reply to Thread
Results 1 to 3 of 3

How to pass dictionary from function

  1. #1
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    How to pass dictionary from function

    Hi i am using late binding and want to pass into my main sub dictionary.

    It looks like:

    Please Login or Register  to view this content.
    how can i get dictionary from function using late binding?
    (i cant use early binding because workbook should be used by other users and manually adding reference for it is not good approach)

    Best,
    Jacek

  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: How to pass dictionary from function

    Jacek

    Since you are dealing with objects you would need at least this in the function.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: How to pass dictionary from function

    Thank you working !

    Jacek

+ 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. [SOLVED] Join 3 arrays/arraylist/ranges and pass them to dictionary
    By jaryszek in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-09-2018, 07:49 AM
  2. [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
  3. How to pass dictionary from function into main sub?
    By jaryszek in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-22-2017, 07:12 AM
  4. Syntax/method to pass an AutoFilter criteria to a Function and use the value in function
    By excelnoobee in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-04-2016, 02:09 PM
  5. [SOLVED] Dictionary or Scripting.Dictionary. Binding Referencing Dim-ing. Sub routines and Function
    By Doc.AElstein in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 07-12-2016, 08:28 AM
  6. Storing a Dictionary into a Dictionary Object
    By pago_boss in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-16-2015, 03:04 AM
  7. Dictionary - Using a dictionary of dictionaries to hold individual orders
    By wazimu13 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-09-2015, 08:32 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