How do I get the number of lines of text in a text box (textbox)

Text Box calculates the number of lines of text entered in a text box can be returned using SendMessage, and when a line of text is wrapped, it is treated as a new line, and the number of newline characters in the text is not simple.

Add the following API function declarations to the general declarations area of the module file.

Option Explicit

Public Declare Function Sendmessagelong Lib _

"User32" Alias "SendMessageA" _

(ByVal hwnd as Long, _

ByVal wmsg as Long, _

ByVal WParam as Long, _

ByVal LParam as Long) as long

Public Const Em_getlinecount = &hba

Form Code

Sub Text1_change ()

Dim LineCount as Long

On local Error Resume Next

' Get/show number of lines of text

LineCount = Sendmessagelong (Text1.hwnd, Em_getlinecount, 0&, 0&)

Label1.Caption = Format (LineCount, "##,###")

End Sub

Note: To make this program successful, set the Multiline property of the text box to true at design time.