ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   character changed event (https://www.excelbanter.com/excel-programming/339134-character-changed-event.html)

gm139

character changed event
 

Does anybody know how it is possible to get an event any time I change a
character in a cell. Of course the event has to be returned without
pressing any termination key (return or tab).

Thanks
Maurizio


--
gm139
------------------------------------------------------------------------
gm139's Profile: http://www.excelforum.com/member.php...o&userid=26951
View this thread: http://www.excelforum.com/showthread...hreadid=401702


Peo Sjoblom

character changed event
 
No, it is not possible

--
Regards,

Peo Sjoblom

(No private emails please)


"gm139" wrote in
message ...

Does anybody know how it is possible to get an event any time I change a
character in a cell. Of course the event has to be returned without
pressing any termination key (return or tab).

Thanks
Maurizio


--
gm139
------------------------------------------------------------------------
gm139's Profile:
http://www.excelforum.com/member.php...o&userid=26951
View this thread: http://www.excelforum.com/showthread...hreadid=401702



Bob Phillips[_8_]

character changed event
 

gm139 Wrote:
Does anybody know how it is possible to get an event any time I change a
character in a cell. Of course the event has to be returned without
pressing any termination key (return or tab).

Thanks
Maurizio


There is no event for entering or changing a character, juts selecting
or changing a cell.


--
Bob Phillips
------------------------------------------------------------------------
Bob Phillips's Profile: http://www.excelforum.com/member.php...o&userid=26952
View this thread: http://www.excelforum.com/showthread...hreadid=401702


Earl Kiosterud

character changed event
 
gm,

You can do this in a text box in a UserForm, with code. You could put the
cell contents into the text box, and update the cell as necessary in code,
with each keystroke.

Private Sub TextBox1_Change()

End Sub

--
Earl Kiosterud
www.smokeylake.com

"gm139" wrote in
message ...

Does anybody know how it is possible to get an event any time I change a
character in a cell. Of course the event has to be returned without
pressing any termination key (return or tab).

Thanks
Maurizio


--
gm139
------------------------------------------------------------------------
gm139's Profile:
http://www.excelforum.com/member.php...o&userid=26951
View this thread: http://www.excelforum.com/showthread...hreadid=401702





All times are GMT +1. The time now is 01:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com