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.