Programing Dialogs in Excel 2002
I am trying to learn to write some dialogs.
I have a Dialog named Main.
On this dialog I have a label "lblDisplay1"
Using the following:
With DialogSheets("Main")
index = .ListBoxes("listboxname").Value
.Labels("lblDisplay1").Caption = "text"
end with
I get a message about cant find the Labels Property
the object browser cant even find DialogSheets yet the statement with
..ListBoxes
works
I also have visual studio on my machine.
I have referenced Excel 10. and VBA .
Very frustaterd that even the basics dont seem to work
|