Hi, I tried many times with macros but wasn't success, I don't know about VBscript on excel 2010. Anybody can help me write the macro for a button that every time I select a cell in the same sheet (B4 to L19) and hit the button, I can select value number in the cell and paste it in C22 cell so that I can do other calculation. Thank you very much.
Hoang
Hi,
One way (which would also avoid the need for a button) would be the Sheet 'Before Double Click' event. i.e.
double click any cell in the range B4:L19 and the value will be placed in C22
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Not Intersect(Target, Range("B4:L19")) Is Nothing Then Target.Copy Destination:=Range("C22") Cancel = True End If End Sub
Regards
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hello Richards, I really appreciate your help.
Seems like I get closer to what I want but the copy value is changed (I just wanna to copy the value, not the equation). I attached here the spreadsheet to see if you can help.
Thank you.
Hoang
Last edited by hoang; 11-25-2011 at 11:13 AM.
hi, hoang, try to change this line in Richard's code:
to this one:Target.Copy Destination:=Range("C22")
Range("C22") = Target.Value
Hello watersev,
The macro runs great now. I'm happy with it.
Thank you guys so much.
Hoang.
@Richard: thank you again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks