I'm gone for the day, but will check back tomorrow. Some suggestions:

Change to

txtCompany.Text = i

to see what value of i comes up and then make sure you have somethin
in that cell.

Use debug.print in your code to see what's going on.

I may try to check back in 5-6 hours, but hopefully, you will hav
solved the problem by then. I did try a quick mock-up on my machin
and got it to work, so I know we are on the right path.

K

P.S. Just read your last post. A frame does sometime complicate thing
(which is why I don't use them). Try to qualify the text box (or th
combobox if that's what you mean) with the frame name.

i.e. UserForm1.Frame1.TextBox

or try removing the frames to see if it is the issue.

P.P.S. As for focus, the focus will be on the control with the lowes
tab order unless you use TextBox1.SetFocus.



--
Message posted from http://www.ExcelForum.com