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!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mrmover

    Using InStr on a Time Cell

    I think you problem is in the 1 you put at the end, Try this... Dim Ti As Variant Dim C As Integer Ti = ActiveCell.Value() C = Instr(1, CStr(Ti), ":") MsgBox (C) The 1 at the end is telling it to only go for 1 char then stop, if you leave it blank it will look at the whole string...
  2. mrmover

    13- Type mismatch

    It might be that rectemp2!YAPAST is a NULL value, to get around this just add & "" to the end of your line . i.e. Select Case rectemp2!YAPAST & "" try that Matt

Part and Inventory Search

Back
Top