Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programing Dialogs in Excel 2002
Chip:
Isn't there the same situation between the UserForms route and the Active X(Control box) route? Tks, Jim "Chip Pearson" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programing Dialogs in Excel 2002
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 "JMay" wrote in message news:3m4Yc.4652$bT1.3814@fed1read07... Chip: Isn't there the same situation between the UserForms route and the Active X(Control box) route? Tks, Jim "Chip Pearson" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programing Dialogs in Excel 2002
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 "Chip Pearson" wrote in message ... 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 "JMay" wrote in message news:3m4Yc.4652$bT1.3814@fed1read07... Chip: Isn't there the same situation between the UserForms route and the Active X(Control box) route? Tks, Jim "Chip Pearson" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel programing | Excel Discussion (Misc queries) | |||
Programing Dialogs in Excel 2002 | Excel Programming | |||
Programing Outlook using Excel | Excel Programming | |||
help with excel programing | Excel Programming | |||
Excel Programing Resources | Excel Programming |