One enter in textbox

N

nd0911

Board Regular
Joined
Jan 1, 2014
Messages
166
hello

I have one big textbox in userform and I want to limit the user to be able to press only one time the "Enter" key (that way he will not have big space's between the line's)

is it possible ?

TNX !!!
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
Sort by date Sort by votes
You could add code to the On Exit event of the text box

Code: 
txt = Split(TextBox1.Text, vbLf)
newTxt = ""
For Each itm In txt
    If itm <> Chr(13) Then newTxt = newTxt + itm
Next
TextBox1.Text = newStr
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Question
Store data input from textbox and store it in cell after push on button
Replies
3
Views
183
Skyybot
Skyybot
C
  • Solved
textbox auto size
Replies
3
Views
110
jkpieterse
jkpieterse
B
  • Question
Userform; open textbox, close it and after that register it
Replies
2
Views
238
dmt32
D
K
  • Solved
Change ComboBox list values depending on the selected OptionButton
Replies
2
Views
198
Kakaska
K
S
  • Solved
have userform textbox run macro without using command button
Replies
5
Views
223
Bosquedeguate
Bosquedeguate

Forum statistics

Threads
1,203,761
Messages
6,057,215
Members
444,914
Latest member
Mamun12345

Share this page

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