Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations waross 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

  1. 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...
  2. Whisperer

    How to eliminate cells that are before 3:00 PM

    Try this: Sub DeleteRow() Dim iRow As Integer iRow = 1 While Cells(iRow, 1) <> &quot;&quot; If Cells(iRow, 1).Value < TimeSerial(15, 0, 0) Then Rows(iRow).Select Selection.Delete Shift:=xlUp Else: iRow = iRow + 1 End If...

Part and Inventory Search