Type13 Mismatch on Find/offset

[SamuelJackson]

hey Guys

So I have a userform with 3 command buttons on it and a textbox
Command button 1 is "previous"
Command button 2 is "exit" not a problem
Command button 3 is "Next" ' where the problem lies!

Looking at sheet1, where a list of names are stored in column A, and numbers/text/symbols (notes) can be stored in column B; It looks for the first instance of the name, the returns the first offset cell in the userform initialise, so that textbox1 automatically has the first note of that person in it.

This code gets so far, then I suddenly get a type mismatch 13, any ideas?

What its doing it taking the value of the textbox1, moving down one cell and making that the new textbox value, then it is looking for that new value, looking at the -1 offset from it, checking whether it is the right name, in column A, if it is, do nothing, if it isnt, the revert to the previous textbox value,

all in all its basically scrolling through the list of notes for that person, but on some people it is getting type mismatch, do I need to dim something, or set and object or something, I'm a bit lost to be honest, column B can be anything, it can even include carriage returns, so I'm not sure what to do next!

Please Login or Register  to view this content.

[Norie]

Can you upload an example workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.