Question: Forms, multi-line input box

cbrf23

Board Regular
Joined
Jun 20, 2011
Messages
241
This is probably a simple question for somebody out there, but I'm not very familiar with forms yet.

Does anyone know how to get a multi line input box; like the one you type into when you create a wordart object?

I'm just looking for the box where you input the text. I like that large box and the fact that you can hit enter and it does a cairrage return/line feed.

I dont need the font and size combo boxes like with the wordart dialog, I just want the big text input box.

I'd like to impliment that in a form I'm trying to create.

Anyone know how to use that box? Or if not, any ideas how I could replicate it?
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
A TextBox should do what you want, if you set the properties properly.
The WordWrap, MultiLine, EnterKeyBehavior and TabKeyBehavior are some of the properties that are directly related to your need.
 
Upvote 0

Forum statistics

Threads
1,224,544
Messages
6,179,430
Members
452,915
Latest member
hannnahheileen

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top