Discussion Article

[ Home | Contents | Search | Reply | Previous | Next ]

Subject:
Problem with Option button control in multiple sheets
Name:
Andrew
Email (spam proof):
Email the originator of this post
Date:
Thursday, June 16, 2005
Hits:
61
Discussion (Terms and Conditions):
My application uses a worksheet which contains some action buttons and an OptionButton ActiveX control. All the code for the buttons is in modules and the option button has no code at all - I just need to be able to read its value. The idea is that the user creates a new instance of this data-entry "form" by creating a copy of the worksheet. The buttons get copied along and continue to function independently across worksheets, using the same code. The option button, however, does not retain its value on each sheet. When I change it on one sheet, it loses its value in all others! What can I do to fix this? Note that I access the button by prefixing it with the worksheet, e.g. ActiveSheet.OptionButton1.Value, but if I click on it in one sheet, then all its instances in all other sheets turn to False. Thanks!

Sponsored by the best FTP application on the internet: