Hash tables are eminently useful structures and I found one for VBA
(http://www.devx.com/vb2themax/Tip/19307) that I'm trying to use. I
have it mostly working but not quite completely. The instructions
say:

NOTE: must make Item the default member, using the Tools | Procedure
Attributes dialog

I haven't done this because I don't have a Tools | Procedure
Attributes dialog. I suspect this is the missing piece in the puzzle
that keeps this class from working completely.

Anyone know how I get to Tools | Procedure Attributes dialog for Excel
2003?

Alternatively if someone knows another hashtable module I would be
willing to try it as well.

Denis

The "modify procedure" menu item is in VB6 not in VBA. To make a property
the default, you need to export the module to a text file, edit some
Attributes (these are similar to compiler directives and will not appear in
the VBA editor), and the import the text file. Complete details are at

http://www.cpearson.com/excel/DefaultProperty.htm


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting LLC
www.cpearson.com
(email on the web site)


"Denis" wrote in message
oups.com...
Hash tables are eminently useful structures and I found one for VBA
(http://www.devx.com/vb2themax/Tip/19307) that I'm trying to use. I
have it mostly working but not quite completely. The instructions
say:

NOTE: must make Item the default member, using the Tools | Procedure
Attributes dialog

I haven't done this because I don't have a Tools | Procedure
Attributes dialog. I suspect this is the missing piece in the puzzle
that keeps this class from working completely.

Anyone know how I get to Tools | Procedure Attributes dialog for Excel
2003?

Alternatively if someone knows another hashtable module I would be
willing to try it as well.

Denis

Other option is to buy VB6, which is worth it in any case, set the default
attribute and compile in VB6 and
then import the .cls file into your Excel project. Have just tried this with
the hash code from Balena and it
works fine.

RBS

"Chip Pearson" wrote in message
...
The "modify procedure" menu item is in VB6 not in VBA. To make a property
the default, you need to export the module to a text file, edit some
Attributes (these are similar to compiler directives and will not appear
in the VBA editor), and the import the text file. Complete details are at

http://www.cpearson.com/excel/DefaultProperty.htm


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting LLC
www.cpearson.com
(email on the web site)


"Denis" wrote in message
oups.com...
Hash tables are eminently useful structures and I found one for VBA
(http://www.devx.com/vb2themax/Tip/19307) that I'm trying to use. I
have it mostly working but not quite completely. The instructions
say:

NOTE: must make Item the default member, using the Tools | Procedure
Attributes dialog

I haven't done this because I don't have a Tools | Procedure
Attributes dialog. I suspect this is the missing piece in the puzzle
that keeps this class from working completely.

Anyone know how I get to Tools | Procedure Attributes dialog for Excel
2003?

Alternatively if someone knows another hashtable module I would be
willing to try it as well.

Denis

On May 22, 1:56 pm, "Chip Pearson" wrote:
The "modify procedure" menu item is in VB6 not in VBA. To make a property
the default, you need to export the module to a text file, edit some
Attributes (these are similar to compiler directives and will not appear in
the VBA editor), and the import the text file. Complete details are at

http://www.cpearson.com/excel/DefaultProperty.htm

After poking around some more I found some info on the Dictionary
object and in particular at your website
http://www.cpearson.com/excel/Collec...ctionaries.htm. It
looks like this object should be sufficient for my needs and it's a
more standard way to go.

Denis