Option Buttons

  • Thread starter Thread starter mudraker
  • Start date Start date
M

mudraker

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
 
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 said:
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


------------------------------------------------

~~View and post usenet messages directly from http://www.ExcelForum.com/

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