Just a quick question...

christianbiker

Active Member
Joined
Feb 3, 2006
Messages
360
Hi all,

I recently upgraded to Excel 2013 and I am trying to use a text box within a form. In Excel 2003 the text box allowed users to enter text and make paragraphs. The Enter key would go to the next line just as it should but in Excel 2013 the enter button forces the cursor off of the text box on to the first unlocked cell at the top of the form or does nothing.

Why is this happening and is there a way around it?
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
19,701
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
Have you tried ALT + Enter ?
What type of text box is it ??
 

christianbiker

Active Member
Joined
Feb 3, 2006
Messages
360
Yep...tried that and some other combos...nothing worked.

It is just a text box selected from the options under "Insert". It doesn't make sense for them to create an option for a text box and not allow me to enter proper text into it in paragraph form. Retarded.
 

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
19,701
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
Ok, I Have just tried that in 2013 and Enter in the text box works fine for me !!
 

Watch MrExcel Video

Forum statistics

Threads
1,122,414
Messages
5,596,001
Members
414,037
Latest member
Roamingsmile

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
Top