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.

Unfortunately these don't work:
SendKeys "%(0128) 'As not the key pad number
SendKeys "(^%e)" 'As it does in Word

If you can arrange for the "?" to be on the clipboard, you can "^v" to paste
it.

Otherwise you may have to add it when edit mode is finished,
_SelectionChange event.
Unless anyone else has bright ideas.

NickHK

"vj5" wrote in message
...
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.

than how can i send the ^v key to excel?

"NickHK" wrote:

Unfortunately these don't work:
SendKeys "%(0128) 'As not the key pad number
SendKeys "(^%e)" 'As it does in Word

If you can arrange for the "?" to be on the clipboard, you can "^v" to paste
it.

Otherwise you may have to add it when edit mode is finished,
_SelectionChange event.
Unless anyone else has bright ideas.

NickHK

"vj5" wrote in message
...
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.

SendKeys, same as they others.

nickHK

"vj5" wrote in message
...
than how can i send the ^v key to excel?

"NickHK" wrote:

Unfortunately these don't work:
SendKeys "%(0128) 'As not the key pad number
SendKeys "(^%e)" 'As it does in Word

If you can arrange for the "?" to be on the clipboard, you can "^v" to
paste
it.

Otherwise you may have to add it when edit mode is finished,
_SelectionChange event.
Unless anyone else has bright ideas.

NickHK

"vj5" wrote in message
...
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.