R
Robert
Hello,
As I am automating a sheet I got stucked with the following:
In a specific sheet (for example Sheet1) I put several Option Buttons,
each button is assigned with a unique name. In another sheet I have put
all the available graphs to which the names in the Option Buttons
refer. What I would like Excel/VBA to do now is that when an Option
Button is selected (in Sheet1), it automatically retrieves the right
graph and puts it in (for example)Sheet2.
Does someone know if there is a VBA command which supports this?
Thanx very much for your help!
Regards,
Robert
As I am automating a sheet I got stucked with the following:
In a specific sheet (for example Sheet1) I put several Option Buttons,
each button is assigned with a unique name. In another sheet I have put
all the available graphs to which the names in the Option Buttons
refer. What I would like Excel/VBA to do now is that when an Option
Button is selected (in Sheet1), it automatically retrieves the right
graph and puts it in (for example)Sheet2.
Does someone know if there is a VBA command which supports this?
Thanx very much for your help!
Regards,
Robert