String over multiple Worksheets
 

Hi
Example:

Have 2 worksheets which have Public stType as String in General Declaration.

When an option button is selected in worksheet 1 then stType = "Testing"

What I would like is to have the stType = "Testing" be in worksheet 2 as
well. This will cut down on refering back to which option button was selected
in worksheet 1.

I hope this make sense.
Thanks
Noemi

String over multiple Worksheets
 

Noemi
If you declare your variable in a module (not on the worksheet) as
Public stType as String
it will be global in scope and both WS's can read/write it.

NickHK

"Noemi" wrote in message
...
Hi
Example:

Have 2 worksheets which have Public stType as String in General
Declaration.

When an option button is selected in worksheet 1 then stType = "Testing"

What I would like is to have the stType = "Testing" be in worksheet 2 as
well. This will cut down on refering back to which option button was
selected
in worksheet 1.

I hope this make sense.
Thanks
Noemi

String over multiple Worksheets
 

Hi Nick
Thank you it worked, never occured to me.

Noemi

"NickHK" wrote:

Noemi
If you declare your variable in a module (not on the worksheet) as
Public stType as String
it will be global in scope and both WS's can read/write it.

NickHK

"Noemi" wrote in message
...
Hi
Example:

Have 2 worksheets which have Public stType as String in General
Declaration.

When an option button is selected in worksheet 1 then stType = "Testing"

What I would like is to have the stType = "Testing" be in worksheet 2 as
well. This will cut down on refering back to which option button was
selected
in worksheet 1.

I hope this make sense.
Thanks
Noemi