View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default ByRef argument type mismatch when passing dictionary object

In the VBIDE, ToolsReferences, and scroll down to Microsoft Scripting
Runtime, and check that box.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"signon77" wrote in message
...
On Jan 8, 1:45 pm, "Bob Phillips" wrote:
Works fine for me.

I presume you have set a reference, and this is all in a standard code
module?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"signon77" wrote in message

...



Hello all,


In one function I am doing the following:


Dim dictMenuOptions As Dictionary
Set dictMenuOptions = New Dictionary
dictMenuOptions.Add "EDIT", "BtnEdit_Click"
dictMenuOptions.Add "COPY", "BtnCopy_Click"
dictMenuOptions.Add "DELETE", "BtnDelete_Click"
dictMenuOptions.Add "PKG EDIT",
"BtnPackageEditor_Click"
dictMenuOptions.Add "OFFICIAL",
"BtnOfficial_Click"


Call RightClick_BlotterMenu(dictMenuOptions)


The first line of "RightClick_BlotterMenu" is defined as :


Sub RightClick_BlotterMenu(MenuOptionsDictionary As
Dictionary)


Does anyone know why I am getting a "ByRef argument type mismatch" ?-
Hide quoted text -


- Show quoted text -



Hi Bob

When you say "set a reference" what does that mean?

Rob