Edit text in an Excel Text Box

%3CLINGO-SUB%20id%3D%22lingo-sub-2020949%22%20slang%3D%22en-US%22%3EEdit%20text%20in%20an%20Excel%20Text%20Box%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2020949%22%20slang%3D%22en-US%22%3E%3CP%3ERecently%20I%20been%20unable%20to%20correctly%20edit%20the%20text%20in%20a%20Text%20Box%20in%20Excel.%26nbsp%3B%20I%20use%20the%20Text%20Box%20to%20assign%20a%20Macro%20Name%20and%20to%20run%20a%20macro.%26nbsp%3B%20The%20Box%20works%20correctly%2C%20but%20the%20ability%20to%20edit%20the%20text%20appears%20broken.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENo%20problem%20starting%20the%20process%20as%20shown%20below.%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22bforman_0-1609260538637.png%22%20style%3D%22width%3A%20198px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F243368iDB320C6388AF50D6%2Fimage-dimensions%2F198x214%3Fv%3D1.0%22%20width%3D%22198%22%20height%3D%22214%22%20role%3D%22button%22%20title%3D%22bforman_0-1609260538637.png%22%20alt%3D%22bforman_0-1609260538637.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20no%20problem%20clicking%20on%20Edit%20Text%20but%20the%20problems%20are%20after%20that.%3C%2FP%3E%3CP%3EIn%20some%20cases%20I%20have%20seen%20the%20place%20to%20edit%20appear%20a%20few%20inches%20to%20the%20right%2C%20but%20you%20can't%20click%20there.%26nbsp%3B%20In%20other%20cases%20it%20appears%20ready%20to%20allow%20for%20the%20text%20edit%2C%20but%20when%20I%20click%20in%20there%2C%20you%20don't%20see%20a%20cursor.%26nbsp%3B%20If%20you%20try%20to%20start%20typing%20after%20the%20click%20you%20don't%20see%20anything%2C%20but%20when%20you%20are%20done%20the%20text%20will%20appear%2C%20but%20probably%20not%20where%20you%20wanted%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can't%20say%20for%20sure%20when%20this%20started%2C%20but%20I%20have%20had%20this%20problem%20multiple%20times%20in%20the%20last%20few%20weeks.%3C%2FP%3E%3CP%3EI%20am%20using%20Office%20365%20with%20the%20following%20information%20shown%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22bforman_5-1609261065981.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F243376iEDF2979D2D7CD729%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22bforman_5-1609261065981.png%22%20alt%3D%22bforman_5-1609261065981.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20do%20most%20of%20my%20work%20via%20Remote%20Desktop%20but%20reproduced%20exactly%20by%20loading%20the%20spreadsheet%20on%20my%20local%20machine.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Visitor

Recently I been unable to correctly edit the text in a Text Box in Excel.  I use the Text Box to assign a Macro Name and to run a macro.  The Box works correctly, but the ability to edit the text appears broken. 

 

No problem starting the process as shown below.

     

bforman_0-1609260538637.png

 

And no problem clicking on Edit Text but the problems are after that.

In some cases I have seen the place to edit appear a few inches to the right, but you can't click there.  In other cases it appears ready to allow for the text edit, but when I click in there, you don't see a cursor.  If you try to start typing after the click you don't see anything, but when you are done the text will appear, but probably not where you wanted it.

 

I can't say for sure when this started, but I have had this problem multiple times in the last few weeks.

I am using Office 365 with the following information shown:

bforman_5-1609261065981.png

I do most of my work via Remote Desktop but reproduced exactly by loading the spreadsheet on my local machine.

 

0 Replies