On Edit Function

[wedzmer]

i was browsing a lot on google hoping to find a VBA code that would act On Edit. Such that on a particular sheet, when I type " / " on a cell and press enter or move on another cell, such character would be replaced with a check (✔️) mark.

Does anyone here know any of this? Or is this even possible?

[Marc L]

Use in the worksheet module its Worksheet_Change event (see samples in this forum or all over the Web) …

[wedzmer]

I haven't found one through searching google...

[btorrean]

Try searching Google using the phrase, "excel worksheet change event example". I tried that and got a number of examples.

Brian

[wedzmer]

I actually fond a VBA Code right here but unfortunately, I'm having trouble editing it, since it's really not working the way I want to....

Please Login or Register  to view this content.

My issues with this is that:

1. It doesn't work on my specified ranges: Columns N to P and Columns BN to BZ
2. The character is actually a square root symbol and not a check mark.

[mjr veverka]

?
Try:

Please Login or Register  to view this content.

[wedzmer]

Thanks a lot man... that works! but it kinda' distorted part of my original intent which was the function to click the cell to put check and double click it to uncheck.

[Bob Phillips]

Please Login or Register  to view this content.

[wedzmer]

it doesn't work sir...

[mjr veverka]

... to click the cell to put check and double click it to uncheck ...

So ... ... what is preventing you from changing the name of the procedure from "_Change" to "_SelectionChange" ?
Try:

Please Login or Register  to view this content.