Hello tehnexus,

sorry to bother you again. after running the recent excel file, I end up having type mismatch run time error on these lines of code
For Each vKey In dic.Keys
Me.cmb1.AddItem vKey
Next vKey

in UserForm_Initialize() subroutine.. no idea why it gives errors like this , I tried setting up these statements for dictionaries..

dic.CompareMode = vbBinaryCompare
dic.CompareMode = vbTextCompare

but no use... can you let me know why? do I need to set any property in cmb1 item?