You would do better rethinking your requirements, rather than trying to run
code in edit mode.
AFAIK, the closest you can get is:
Range("A1").Select
SendKeys "{F2}"
SendKeys "{LEFT}"
SendKeys "{LEFT}"
SendKeys "&"
NickHK
"vj5" wrote in message
...
than how insert--symbol is working in excel?
if its working than there should be some way to do that.
can i invoke insert-symbol -- from my command button
"Mike Fogleman" wrote:
Not in edit mode. While you are editing, the cell contents or value is
still
up for grabs, under construction. There has been no commitment to a set
value for the application or code to deal with.
Mike F
"vj5" wrote in message
...
thanks for reying :)
is there any mothod, i can do that ?
any link or example ?
or can you explain me how internally methods are invoking at the time
of
editing the cell .
as its working in case of insert---symbol feature of excel
can i invoke that toolbar's command button event to insert the
symbol?
"vj5" wrote:
Hi Experts
i am trying to write text on excel sheet ,i am using the following
code:
appXl.ActiveCell.Value2 = "Sample Text";
this is working fine when a cell is selected but
its not working when the cell in edit mode.