Hi,
While accessing the control values options, object required error is existing. May i know the reason for this...? Please find the code below.
![]()
Please Login or Register to view this content.
Hi,
While accessing the control values options, object required error is existing. May i know the reason for this...? Please find the code below.
![]()
Please Login or Register to view this content.
Last edited by davesexcel; 04-25-2012 at 06:26 AM.
Regards,
Deva
hi Deva,
Please use code tags when supplying VBA code.
What's Testing_Click? If you haven't a control called Testing then you will get the error
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
Hi RoyUK,
Testing is the button name. In the controls am able to access only the button_click method . Other than that, am not able to access the button properties like, button.enabled = true etc.. If i used this kind of statement means, the object required error is occuring. May i know the reason for this.?
Regards,
Deva
is it a button from the Forms controls? If it is then they don't have those properties
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks