I have a activex radio button that is named ship on a sheet that is named "invoice". I am trying to write a macro that will make a decision on what to do based on the state of that radio button. I don't know the correct synatx to call it. I have tried code like:
if sheets("invoice").ship = true then
(which didn't work)
or
if ship = true then
(which didn't work either)
Can someone give me a hand here?
Thanks,
John
if sheets("invoice").ship = true then
(which didn't work)
or
if ship = true then
(which didn't work either)
Can someone give me a hand here?
Thanks,
John