| Often, you may need to know how many lines of text there are in a multi-line textbox. While Visual Basic makes it easy to determine how many paragraphs the textbox contains, using code like so: Private Sub Command1_Click() Dim myParas As Variant myParas = Split(Text1, vbNewLine) MsgBox UBound(myParas) + 1 End Sub This code, as you can see, only parses out hard carriage returns; whereas you want to know how many lines of text the control contains. To accomplish this task, you'll need to resort to the SendMessageAsLong() API function. This function conforms to the following syntax: Private Declare Function SendMessageAsLong Lib "user32" _ Alias "SendMessageA" (ByVal hWnd As Long, ByVal wMsg As Long, _ ByVal wParam As Long, ByVal lParam As Long) As Long To obtain the number of lines, you pass in the EM_GETLINECOUNT constant in the wMsg parameter. Declare this constant like this: Const EM_GETLINECOUNT = 186 Finally, to use the function, pass in the handle to the textbox from which you want to retrieve the line count, as well as the wMsg we mentioned earlier. Example code might look like so: Private Sub Command2_Click() Dim lCount As Long lCount = SendMessageAsLong(Text1.hWnd, EM_GETLINECOUNT, 0, 0) MsgBox lCount End Sub |
Counting lines in a multi-line textbox |
Freelance ASP PHP web development | Web developer India Web development India| Prayagasoft - web designer India, Ecommerce developer india, Ecommerce design