Can Chr(182) or "¶" function like chr(10) or Linefeed character in a Textbox whose multiline value is False

SamDsouza

Board Regular
Joined
Apr 16, 2016
Messages
187
Hello

Why can't Chr(182) or "¶" function like chr(10) or Linefeed character ?

When anything typed in a particular cell or range of cells with ALT+Enter.

The text is broken with Lines in a cell and the same is represented in Textbox (whose Multiline Property value is set to False) is represented with "¶" after each text.

As I don’t have more space to in incorporate Textboxes with MultiLine and increase the height of textbox
Representation 1
J​
K
1
2Sam
D’souza
22

VBA Code:
StrText1= Textbox1.Text
StrText2=Textbox2.Text

With wks.Cells(2, 10)
   .Value = "(" & strText1 & ")" & Chr(10) & StrText2
End With
TextBox3.Value = wks.Cells(2, 10).Value

Textbox3.Value displayed as with above code

Sam¶ D’souza¶ 22


Now in reverse manner ie From userform Textbox to worksheet cell
i type chr(182) after each text in Textbox1 and Textbox2 ie

VBA Code:
StrText1= Textbox1.Text
StrText2=Textbox2.Text

With wks.Cells(2, 10)
 .Value = "(" & strText1 & ")" & Chr(182) & StrText2
End With
TextBox3.Value = wks.Cells(2, 10).Value

When with above code
Sam¶ D’souza¶ 22 is Typed
I get in cell
Representation 2

J​
K
1
2Sam¶D’souza¶22

and not same with LineFeed after each Text which is shown in Representation 1

This beautiful chr(182) or ¶ at least indicates where ALT+Enter has been pressed in a Cell inbetween the strings in a single Textbox whose multiline = False

Will it be possible to use chr(182) or “¶” instead of chr(10) LineFeed character in single Line Textbox so that cell in worksheet is displayed like representation 1

Your guidance and help shall be appreciated

Thanks
SamD
169
 

SamDsouza

Board Regular
Joined
Apr 16, 2016
Messages
187
The number keypad is normally to the right of the main keypad, although I don't think all laptops have that.
Yes Tradtional CPU with Seperate Keyboards connected to CPU

So Now How does one go about resolving Keypad issue
Sorry Now i cant purchase traditional CPU Old Keyboard with Numeric keypad on right side😜

174
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
53,071
Office Version
  1. 365
Platform
  1. Windows
Do you have a number pad, or just the numbers above the main keys?
How are you currently inserting the ¶ symbol?
 

SamDsouza

Board Regular
Joined
Apr 16, 2016
Messages
187
Fluff
Do you have a number pad, or just the numbers above the main keys?
I am Sorry i am not able to get you. It seems there is no number pad but Laptop Keyboard with Number and Symbols from ! to ) above the 10 Numbers.

How are you currently inserting the ¶ symbol?
Well I copied from Ascii Chart from VBA Strings & Characters - ASCII Characters and pasted it in Notepad.
in same way i copied from above URL and pasted in textbox. This gave the LineFeed in Cell of worksheet

I am sorry. This way Copying from Ascii chart from a particular website and pasting it in a text box will be always frustrating.

SamD
175
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
53,071
Office Version
  1. 365
Platform
  1. Windows
If I copy that character from that site & paste it into a textbox, when I transfer the textbox value to the sheet & I get the line feed & not the character.
 

SamDsouza

Board Regular
Joined
Apr 16, 2016
Messages
187

ADVERTISEMENT

If I copy that character from that site & paste it into a textbox, when I transfer the textbox value to the sheet & I get the line feed & not the character.
Exactly Fluff You are right and the same is mentioned in #14 by me 👇
This gave the LineFeed in Cell of worksheet
So First of all how can i get ¶ when typing in a text box and the same LineFeed is derived in a cell on worksheet with the laptop i have
SamD
176
 

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
36,691
Office Version
  1. 2010
Platform
  1. Windows
I am Sorry i am not able to get you. It seems there is no number pad but Laptop Keyboard with Number and Symbols from ! to ) above the 10 Numbers.
If you don't have a separate number pad on your laptop, then the number pad equivalent is embedded in right side of the letters on keyboard. They are usually identified on the face of the keys but I have also seen them on the front side of the keys as well. This link should help you find it...
.
How to Use the Numeric Keypad on Your Laptop - dummies
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
53,071
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

I've no idea, as I don't have a laptop. Have a look here & see if it helps
 

SamDsouza

Board Regular
Joined
Apr 16, 2016
Messages
187
Fluff and Rick
Thanks for the references
Let me try on how to use Numeric Pad on Laptop and revert back to you

But the question will always remain when Macro .xlsm file sent with above requirement ie with ¶ chr(182) in a textbox or emailed to user whether he is using Laptop or Desktop how will one know. ? This will be also frustrating in asking whether using Laptop or desktop
Reply from Fluff
I've no idea, as I don't have a laptop. Have a look here & see if it helps

Let me work on numericapad in Laptop and revert back to you.

GN

SamD
177
 

SamDsouza

Board Regular
Joined
Apr 16, 2016
Messages
187
Fluff and Rick I am really sorry for the reply on the same. FYI my Left hand fingers got numb severe pain in my neck and was on bed rest for last 14 days.
It seems i've to get a numeric keypad addtionaly and attach to Laptop.

Thanks
SamD
178
 
Solution

Watch MrExcel Video

Forum statistics

Threads
1,122,850
Messages
5,598,457
Members
414,239
Latest member
xnanx

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