I am trying to learn to write some dialogs.
Dialogs were replaced by UserForms in VBA. Don't waste your time
learning about Dialogs. Use UserForms instead.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"ken" wrote in message
...
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