Update cell value from anohter worksheet

Hello,

I have two different ranges in worksheet3 which you can select with
option button.
By selecting option button 1 it shows values of range1 in worksheet1,
and by selecting option button 2 it shows values of range2 in
worksheet1. Values are shown in same range in worksheet1, and
everything goes ok this far.

The promblem is that values won't update to worksheet1 without
selecting first another option button.

ie. if option button 1 is selected it shows values in worksheets1&3,
but after changing some of the values in range1 I have to select option
button 2 and again option button 1 to update the values in worksheet1.

I've tried some if-thens but just can't get it to work, any ideas...?

Regars, Mardo

If your code does a copy and paste, try doing a pastespecial and select paste
link. Then you will have formulas in the cells that update.

--
Regards,
Tom Ogilvy


"mardo@jippii.fi" wrote:

> Hello,
>
> I have two different ranges in worksheet3 which you can select with
> option button.
> By selecting option button 1 it shows values of range1 in worksheet1,
> and by selecting option button 2 it shows values of range2 in
> worksheet1. Values are shown in same range in worksheet1, and
> everything goes ok this far.
>
> The promblem is that values won't update to worksheet1 without
> selecting first another option button.
>
> ie. if option button 1 is selected it shows values in worksheets1&3,
> but after changing some of the values in range1 I have to select option
> button 2 and again option button 1 to update the values in worksheet1.
>
> I've tried some if-thens but just can't get it to work, any ideas...?
>
> Regars, Mardo
>
>

Thanks Tom but my code doesn't copy and paste

I just get the value like this:
Worksheets(1).Range("Range1").Value =
Worksheets(3).Range("Range").Value


Mardo