ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   writing excel (https://www.excelbanter.com/excel-programming/366240-writing-excel.html)

vj5

writing excel
 
i wanted to insert a symbol in a cell while cell is in edit mode. i alraedy
post questions and goit reply its not possible.
Now my question is that : if its not possible than how insert--symbol is
working in excel.
can i diactivate edit in cell and after inserting again activate edit in
cell?


Norman Jones

writing excel
 
Hi VJ,

Since a macro cannot run when Excel is in edit mode, it would not be
possible, programmatically, to deactivate the cell.

It is certainly possible to use VBA to insert a symbol - but not if Excel is
in edit mode.


---
Regards,
Norman



"vj5" wrote in message
...
i wanted to insert a symbol in a cell while cell is in edit mode. i
alraedy
post questions and goit reply its not possible.
Now my question is that : if its not possible than how insert--symbol is
working in excel.
can i diactivate edit in cell and after inserting again activate edit in
cell?





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

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