Results 1 to 9 of 9

dictionary as public must calling

Threaded View

  1. #1
    Forum Expert
    Join Date
    11-28-2015
    Location
    indo
    MS-Off Ver
    2016 64 bitt
    Posts
    1,513

    dictionary as public must calling

    I have coding i am store data as dictionary
    dim dic as new scripting.dictionary
    Sub mydic()
    For each x in array("a","b" "c")
    dic.add x,nothing
    Next x
    End sub
    When dictionary using in sub makro
    This bellow is error
    sub aa()
    Dim r as range
    For each r in [A1:A10]
    If dic.exists(r.value)
    Then
    Msgbox "data valid"
    End if
    Next r
    End sub
    But if using call mydic ,that will be sucses
    sub aa()
    Call mydic 'must calling how to do dictionary can redefine r has exists or not without call
    Dim r as range
    For each r in [A1:A10]
    If dic.exists(r.value)
    Then
    Msgbox "data valid"
    End if
    Next r
    End sub
    Last edited by 6StringJazzer; 02-12-2018 at 10:52 AM. Reason: removed incorrect characters from title

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Dictionary as public
    By daboho in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-20-2017, 02:51 PM
  2. Bad Syntax for calling public variables
    By lordterrin in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-04-2013, 04:24 PM
  3. Calling a Public Loop
    By justforthis1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-08-2012, 02:56 PM
  4. Calling a public function from userform
    By BBQNJL in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-09-2009, 05:38 PM
  5. Calling a DLL from Excel.:public domain
    By Jim15 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-02-2007, 02:40 PM
  6. Calling a Public Subroutine in a Different Workbook
    By Raul in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-24-2005, 12:05 AM

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