User Profile

joelin139 · Apr 1 '14, 04:51 PM

Dear Guru
how can i sort listbox with vbTab my code is

Code:

Dim i As Long, TPts As Long, LPts As Long
 Dim User As String, LText As String
 If List2.ListCount = 0 Then                     'default, just enter & exit
  List2.AddItem Text5.Text & vbTab & Text6.Text
  Exit Sub
 End If
 LText = LCase$(Text5.Text)                      'case sensitive search
 TPts =

...

joelin139 · Mar 22 '14, 03:10 PM

Dear Guru,
i have listbox data :

morning;Good Morning
evening;Good Evening
afternoon;Good Afternoon

i have text1 text2 and command1 so what i want is like this

when text1 enter morning command1 click text2 will show Good Morning
when text1 enter evening command1 click text2 will show Good Evening
when text1 enter afternoon command1 click text2 will show Good Afternoon...

User Profile

Profile Sidebar

Sort Listbox with second column vbTab

how to replace text in listbox to textbox