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.

VBA code will not run while a cell is in edit mode.
Mike F
"vj5" wrote in message
...
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.

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.

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.

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.

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.

thanks for reply
i already tried with sendkeys but its for normal characters only.
i wants to send character like :"‚¬" (alt+0128)
its not working in that case its displaying character:"¬"
How i can send character " ‚¬" with sendkeys?

thanks again...

"NickHK" wrote:

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.