Programing Dialogs in Excel 2002

K

ken

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
 
C

Chip Pearson

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
 
J

JMay

Chip:
Isn't there the same situation between the UserForms route and the Active
X(Control box) route?
Tks,
Jim
 
C

Chip Pearson

I'm not sure what you mean? Do you mean between Forms commandbar
controls and Controls (ActiveX) controls?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
J

Jim May

Yes,,,
Wasn't sure how to phrase the question, not knowing the
proper terminology and all.
Sorry - I failed to check back on this sooner.
Jim May
 
Top