Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a dictionary object which I need to:
1) Create and modify upon opening the workbook (it draws data from the workbook for its keys and objects) 2) Read and write to in userform and module level code I haven't used dictionaries before. Can someone point out where I have gone wrong? It is giving me a Error: Variable not defined at the Module level code. What follows isn't my actual code, but it should give you an idea of what I am trying to do. <This Workbook 'Declarations Option Explicit Public dictCornerCellPics Private Sub Workbook_Open() Set dictCornerCellPics = CreateObject("scripting.dictionary") dictCornerCellPics.add "a", worksheets(4).cells(1,2) dictCornerCellPics.add "b", worksheets(4).cells(2,2) ...etc.... End Sub </This Workbook <module code Public Sub MakeCorners (strng as String) as Boolean dictCornerCellPics.add strng, worksheets(3).cells(1,1) ...etc.... MakeCorners = dictCornerCellPics.exists("a") End Sub </module code Thanks in advance, (someday, in a galaxy far far away, I'll be able to end a post with HTH...) -Abe |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
XL 07 Initializing Folders | Excel Discussion (Misc queries) | |||
stop userform from initializing | Excel Programming | |||
Initializing Combobox in a Userform | Excel Programming | |||
Initializing Userform | Excel Programming | |||
Initializing User Forms | Excel Programming |