Floating Text Box (or something similar) that can be edited

[Bimmy]

Hello,

Looking for a floating text box (or something similar) that can be edited in real time.

Attached is a file shared by Hui on below post -

http://forum.chandoo.org/threads/floating-info-box.28641/

It achieves 2 things I was looking for -

1) Floating text box, and
2) It remains afloat when I jump to sheet 2

I'm looking for a floating text box (or something similar) in which I can add and delete information.

Is this possible

 

[Hui]

See attached version
You can change the text on the Setup Worksheet

 

[Bimmy]

Thanks for responding Hui.

While playing around I found out that you can EDIT text in the Floating Text Box that appears.

One difficulty I'm facing is, if I want to type on next line, I have to finish the line which I started and then it automatically jumps to the next line.

Your idea is good, but, in our work environment where every minute is of absolute importance this will be overlooked.

In the floating text box is there any way to jump to next line as and when required.

 

[Bimmy]

Hello Hui,

After playing around with the properties I finally have what I'm looking for.

After selecting the textbox, in properties check EnterKeyBehaviour = True. This now allows me to jump to next line as and when required.

I tried it on your floating text box and it perfectly suits my requirement.
This completely removes dependence on a cell or a range.

This may be helpful to you in some way.

 

[Hui]

Great outcome
It maybe worth having the text box load a default set of text when it loads or the workbook first opens

 

[Bimmy]

That would be useful.

I was thinking a bit different here.

Can you reverse the idea you have used.

Currently what the code does is, it loads information contained in sheet Setup cell C3.

Is there a way the code can store information typed in the floating box in sheet Setup cell C3.