ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Programing Dialogs in Excel 2002 (https://www.excelbanter.com/excel-programming/308298-programing-dialogs-excel-2002-a.html)

Ken

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


All times are GMT +1. The time now is 05:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com