Option Buttons

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
 
C

Chip Pearson

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
Click to expand...
to creating financial statements
 
Top