On_Click ?

[Num-Cha]

Just wondering if it's possible
to have onclick_events

So that if i was to click on a cell it would delete the text in a few other cells for me
a delete cell_button

Thanks

[StephenR]

You can use the Worksheet Change or Selection Change events. What exactly do you want to do?

[Num-Cha]

Well im in need of a on_click event that deletes the text in certain cells . Any Ideas ?

[teylyn]

Num-Cha

please don't quote whole posts. It's just clutter. In fact, only quote when you are referring to something particular that is not in the previous post, and then only quote the pertinent lines.

Thank you.

[Cheeky Charlie]

on_click applies to activex objects, I don't think you're there yet, selectionchange has already been pointed out, to try it out, go to the code of a sheet, above the main VBA editing window are two drop down boxes, the first probably says (General), select Worksheet, the second probably (now) says SelectionChange and you will have a little selection change macro all ready to go. The first thing you want to do is test the target cell (the one to which selection has been changed) to check it's the right cell for your purposes... then go nuts.

CC

[martindwilson]

I supose you could use the before double click or before right click options e.g.

Please Login or Register  to view this content.