+ Reply to Thread
Results 1 to 2 of 2

Copy a value to Dictionary

  1. #1
    Registered User
    Join Date
    12-27-2012
    Location
    Chennai
    MS-Off Ver
    Excel 2007
    Posts
    60

    Copy a value to Dictionary

    Hi,
    Can anyone help me on how to add a value to dictionary object.
    There is a variable(say VSinput) inside a while wend loop.Its value keeps on changing.
    I want to add the VSinput to a new dictionary object.
    I dont know how to create a dictionary and use it...But have seen examples.I am not able to understand those.

    Please Login or Register  to view this content.
    This is inside a Class module.

    Thanks...

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Copy a value to Dictionary

    I would avoid using a While/Wend loop. Instead try using a For/Next loop. I tried to incorporate your structure as much as possible so you can understand.

    Please Login or Register  to view this content.

+ 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. 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
  2. vba dictionary
    By kieranbop in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-20-2011, 06:06 AM
  3. Dictionary Object
    By AdamDay in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 01-29-2008, 07:44 PM
  4. HELP-Dictionary
    By dfisch8 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-22-2005, 04:05 PM
  5. [SOLVED] Dictionary
    By Jac Tremblay in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-22-2005, 04:06 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