Quote Originally Posted by Kenneth Hobs
The only difference it would probably make is if others run the code and don't have that file. You can always download the latest version from Microsoft. However, try what you have is my suggestion since most of your users are probably using what you are.
I have indeed tried it and it does work, i'm just in the process of changing some sections of the code and adding the code to work with the CanxData form. You've shown me some interesting things in the code, especially with some of the tweaks you made to mine...
( cboTLName.List = WorksheetFunction.Transpose(ws.Range("TeamLeaders")) ).

It gets interesting now as i now need to get data from Access and into an Excel userform... i've posted in the access forum about this one. I'll mark this thread as solved now, as you've helped me so much with this one.

thanks Kenneth