By the way, another way to test if the control is a TextBox is like
this...

If TypeOf Ctrl Is TextBox Then

Since Excel has a textbox object and the object on the userform
is not that object, it might be better to qualify

If TypeOf Ctrl Is Msforms.TextBox Then

Good point! Thanks for following up on that for me.

Rick