UserForm for data entry

Originally Posted by PMO

Hello,

Change

  If var(i&, 1) = Trim(Me.CombTicker.Value) And _
      var(i&, 3) = Trim(Me.CombNoofStock.Value) Then

by

  If Trim(CStr(var(i&, 1))) = Trim(Me.CombTicker.Value) And _
      Trim(CStr(var(i&, 3))) = Trim(Me.CombNoofStock.Value) Then

Best regards.

PMO
Patrick Morange

thanks a lot it work like charms
thanks again