In a previous post he said click on a button.


You can use the selectionchange event to trigger an action on cell
selection, but this is usually clumsy and works whenever the cell is
entered, even if not with a mouse click.

--
Regards,
Tom Ogilvy


David wrote in message
...
I guess cakonopka meant "when i click the cell", didn't you ?
So is there a way to make SUBs on the events On_click in a cell ?


"Tom Ogilvy" a écrit dans le message de
...
Private Sub CommandButton1_Click()
Range("A1").Copy Destination:=Range("B9"
Range("A1").ClearContents
End Sub


--
Regards,
Tom Ogilvy

"cakonopka " wrote in message
...
Hi there all

a problary most simple thing for you, im looking for a macro where ti
will move the data from one cell to another when i click it, thats it,
i know there is problary some simple thing but i dont know it, lol.

if u cant do it please let me know so i can stop trying, lol

cheers

from ck


---
Message posted from http://www.ExcelForum.com/