I'm probably going to embarass myself because I'm a COMPLETE novice with VBA... and I'm not even sure if what I'm posting will make any sense!
I'm wondering if your data types are messing things up at all?
You mentioned a text box, is the data type an integer or text?
:confused: