View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Programing Dialogs in Excel 2002

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