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...Originally Posted by Kenneth Hobs
( 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![]()