ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   referencing a control (https://www.excelbanter.com/excel-programming/285468-referencing-control.html)

Harold[_3_]

referencing a control
 
I've been modifying an old dialog box I designed earlier,
and added two new labels and a spinbutton. I've
referenced them in code just as I have all the other
labels and controls, but for some reason the compiler
doesn't seem to recognize the new controls. What's going
on?

Harold

patrick molloy

referencing a control
 
are you really referring to a "dialog sheet" ? Which
version of Excel are running. These are Excel95/97
Do you mean that you are adding controls to a userform?

Its possible that you're seeing a red
herring...sometiomes Excel throws an error on an object
when in fact the error is something different. One chech
is to open the IDE. look in Tools/References and check
that there are none missing.

Patrick Molloy
Microsoft Excel MVP

-----Original Message-----
I've been modifying an old dialog box I designed

earlier,
and added two new labels and a spinbutton. I've
referenced them in code just as I have all the other
labels and controls, but for some reason the compiler
doesn't seem to recognize the new controls. What's

going
on?

Harold
.



All times are GMT +1. The time now is 04:22 PM.

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