Accessible multi-line rich edit control

[Tom A]

Hi, I have large amounts of text in the cells in my worksheet. At the moment, if I want to edit one, I have to press F2, and Ctrl + shift + home to select it and paste it into Wordpad and make any changes there as it formats the text correctly and then paste the text back into my worksheet.

I'm using screenreading software and am looking for an accessible rich edit control to use on a user form. The wordpad edit control is accessible and the rich edit field used in the Outlook 2013 contacts form for the notes is also accessible but I don't know if VBA has access to these.

Any suggestions will be appreciated. The standard text box in VBA isn't v accessible.

Thanks,

 

[vletm]

@Tom A
Do a sample file and upload it here,
then You could get quicker answer/suggestion.

 

[Tom A]

I've attached a sample user form with a long piece of text in cell A1. It has a single text box with two buttons on the user form. It takes the contents of the active cell and displays them in the text box. Once you've made any changes, you click on the save button to save the text back in the cell.
I am looking for a rich edit text box control like the one used by outlook in the notes field of the contacts form or Wordpad.

@Tom A
Do a sample file and upload it here,
then You could get quicker answer/suggestion.

 

[vletm]

@Tom A
The 1st version ...
> Activate Cell > press ["the button"] >> Edit >> [Save] or [Close]
for testing ...

 

[Tom A]

Thanks vletm. I'm using the keyboard only with screenreading software. I thihnk you've put the rich edit control on the worksheet itself? I've had a quick try and I don't think I will be able to access that control.

Is it possible to have a rich edit control in the user form that's in that spreadsheet instead? There's a text box control on that form along with two buttons but I'd like a Rich Edit control instead.

 

[vletm]

@Tom A
That is 'normal' Excel's Textbox.
It just take activecell's value to default Textbox (+Arial regular fontstyle).
It's possible to edit.
Save copies Textbox's value to activecell and deletes Textbox.
Close only deletes Textbox.
You can make wider longer that Textbox as You want.
> Your Form ...
Have You tried to change Font to Arial?
It's fixed size textbox .. then font size need to be small
with sheet's Textbox as I wrote,
it's easier to make bigger or smaller box.

 

[Tom A]

Hi vletm, Do you know what the maximum character limit for the standard text box control is?

 

[vletm]

@Tom A
No!
Have You tried to 'Google' that information? I didn't find helpful information.
Have You tried to test?

 

[Tom A]

I've tried googling it and some places seem to say it has a maximum limit of about 32000 and some places say about 64000 characters for a text box that has the multiline property set to true.
I will test it out at some point over the next few days.