Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Whisperer
-
vba - how do I put excel column in vba listbox
Don, although your efforts to use VBA are commendable, there is no need to use it to populate your listbox. As JockeK has already stated, the only thing that you need to do is to tell the listbox the RowSource criteria. In the VBA editor if you right-click on the Listbox concerned and select...- Whisperer
- Post #3
- Forum: Microsoft VBA - Visual Basic for Applications
-
How to eliminate cells that are before 3:00 PM
Try this: Sub DeleteRow() Dim iRow As Integer iRow = 1 While Cells(iRow, 1) <> "" If Cells(iRow, 1).Value < TimeSerial(15, 0, 0) Then Rows(iRow).Select Selection.Delete Shift:=xlUp Else: iRow = iRow + 1 End If...- Whisperer
- Post #2
- Forum: Microsoft VBA - Visual Basic for Applications
