control toolbox vs forms toolbars
Hi,
I have BIG issue! On Sheet1 I have 2 OptionButton's (OptionButton1 and OptionButton2, as name box shows me). Problem is in the fact that they are from Control toolbox and they are not linked to any cell or variable. I need to check which one is selected! I do now the procedure when working with Forms toolbar but how to work with OptionButton from control toolbox which is placed on sheet?!?! Any idea? for example: If [OptionButton1] = true then ' write something in cell AV6 Else ' write something else in cell AV6 EndIf of course, this is not working... please, anyone..... |
All times are GMT +1. The time now is 07:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com