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

[SamDsouza]

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
2	Sam D’souza 22

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

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
2	Sam¶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]

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

 

[Fluff]

Do you have a number pad, or just the numbers above the main keys?
How are you currently inserting the ¶ symbol?

 

[SamDsouza]

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]

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]

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]

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]

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

How to Use Num Pad and Numlock on Laptop

Learn how to use numpad (numeric keypad) and numlock on a laptop. Num lock key controls the num pad activation.

techwelkin.com

 

[SamDsouza]

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]

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