Append text to a cell in edit mode of excel sheet...

[Harish Shinde]

Hi,

I am unable to write/append some text to the cell (excel sheet) in edit mode from my custom toolbar while I m able to write on complete cell (not on edit mode) using following code

appXl.ActiveCell.Value2 = "Sample Text";

Can anyone help me for adding a text to a cell in edit mode of excel sheet.

Regards,

-Harish Shinde

 

[Nick Hodge]

Harish

You can't do anything in code while Excel is in edit mode, if that's what you mean

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)


Hi,

I am unable to write/append some text to the cell (excel sheet) in edit mode from my custom toolbar while I m able to write on complete cell (not on edit mode) using following code

appXl.ActiveCell.Value2 = "Sample Text";

Can anyone help me for adding a text to a cell in edit mode of excel sheet.

Regards,

-Harish Shinde

 

[Harish Shinde]

Yes Nick, you are right I m not able to do anything when the excel is in edit mode....

-Harish Shinde
Harish

You can't do anything in code while Excel is in edit mode, if that's what you mean

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)


Hi,

I am unable to write/append some text to the cell (excel sheet) in edit mode from my custom toolbar while I m able to write on complete cell (not on edit mode) using following code

appXl.ActiveCell.Value2 = "Sample Text";

Can anyone help me for adding a text to a cell in edit mode of excel sheet.

Regards,

-Harish Shinde