Option Buttons
 

I have several Form Option buttons on a Excel 97 worksheet

I can get the desired results using this code

vAr = Worksheets("menu").optSourceInet.Value

Is their away of getting the same result using

set wsMenu = worksheets("Menu")

var = wsMenu.??????????.value


thanks

In Advance


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements

Option Buttons
 

Yes, you can do this if you declare your variable wsMenu As
Object rather than As Worksheet.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"mudraker" wrote in
message ...

I have several Form Option buttons on a Excel 97 worksheet

I can get the desired results using this code

vAr = Worksheets("menu").optSourceInet.Value

Is their away of getting the same result using

set wsMenu = worksheets("Menu")

var = wsMenu.??????????.value


thanks

In Advance


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide
to creating financial statements

Option Buttons
 

thanks Chip


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements