combobox in an addin

[impius]

Hello, I have created an addin and the data populating the comboboxes on my userform are not populating. It works fine when I view it in its original workbook rather than as an addin. The rowsource is set to Sheet2!b1:b2. can it not read this when it is saved as an addin?

Thanks

[lucas]

Without re-creating it I would have to take a guess. Since you are setting the rowsourse in properties it is probably looking in the addin....

You might have to populate the combox in the userform initialize and use activeworkbook, not thisworkbook to qualify the range.