Excel - Plading a value in a cell 2

[shytott]

Hi
If I have a summed value in cell A5 is there anyway to place that value into C5 but without having the formula '=A5' in C5. What Im wanting to do is to have a macro button which will make A5 and C5 be at the same value but only when the button has been pressed - otherwise with =A5, it will be continually updated.

Hope thats not too double dutch!

Many Thanks

 

[SkipVought]

Hi,
[c]
sub GetValue()
with Sheets("YourSheetName")
.[C5].Value = .[A5].Value
end with
end sub
[/c]
copy and paste into a VBA module.

Place a Forms button on your sheet and Assign this procedure

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[white605]

Record the macro.
check this out

http://support.microsoft.com/kb/141689

This old world keeps spinning round - It's a wonder tall trees ain't layin' down

 

[shytott]

Cheers Skip

You came up Trumphs again! That works perfectly



White605,
I had tried recording a macro doing the job manually, but it always left a formula in C5 and not just the integer value of A5. Thanks for replying.

 

[lionelhill]

If you want to do this by recording a macro, try using "paste special, value" instead of just pasting. Might help.

 

[shytott]

Spot on Lionel, that works a treat too - I knew there'd be some way of doing it by recordable actions. Ive learned something new about Paste Special too.

Much Obliged

Shytott