Buttons on userform not behaving correctly.

here's the modified code for the next and prev buttons, if there are blanks, ie when you open the form it is overwriting the data in your range with those blanks, these if statements say if the userform has a blank then do nothing since it is just like flipping a page. in the long run you will need to add code that recognizes changes to each = UserForm1.name.value so if you make a change it will append the record

something like, tn = UserForm1.txtTrackingNumber.Value

then, if UserForm1.txtTrackingNumber.Value <> tn then Range("A" & CurRow).Value = UserForm1.txtTrackingNumber.Value

and so on

Please Login or Register  to view this content.

for the second part i would use a second form i added it to your project

Test 1 Internal Courier Tracking - Copy.xlsm