akn112
01-23-2008, 08:08 AM
Hi all,
I'm working with excel trying to get my option buttons to work. Since i'm coming from an access background, there's some transitional things i'm trying to work out. So in my worksheet i've added to option buttons and when i click "add macro" it shows OptionButton11_click. So intuitively my code reference looks like
if OptionButton11 then
...
end if
But it can't seem to find the object. Is there something i'm missing? Also, is it possible to change the name? thanks.
EDIT:
I've attached the database. It is currently working, however, not the way i'd like. Instead of accessing the option button properties, i've set it to write a number value (0 or 1) to a field at A100. Please ignore the download and upload sheets.
I'm working with excel trying to get my option buttons to work. Since i'm coming from an access background, there's some transitional things i'm trying to work out. So in my worksheet i've added to option buttons and when i click "add macro" it shows OptionButton11_click. So intuitively my code reference looks like
if OptionButton11 then
...
end if
But it can't seem to find the object. Is there something i'm missing? Also, is it possible to change the name? thanks.
EDIT:
I've attached the database. It is currently working, however, not the way i'd like. Instead of accessing the option button properties, i've set it to write a number value (0 or 1) to a field at A100. Please ignore the download and upload sheets.