Hi,
I currently have a combobox on a worksheet that I want to fill with a list of suppliers.
The list of suppliers are contained in a column on another workbook.
I have used the workbook_open() function to open the supplier workbook when the other workbook opens up.
I have changed the ListFillRange property of the combobox to fill it correctly, however when I close both files, the next time I open them the combobox is empty.
How do I code it so it fills every time I open the file?
Thanks in advance
I currently have a combobox on a worksheet that I want to fill with a list of suppliers.
The list of suppliers are contained in a column on another workbook.
I have used the workbook_open() function to open the supplier workbook when the other workbook opens up.
I have changed the ListFillRange property of the combobox to fill it correctly, however when I close both files, the next time I open them the combobox is empty.
How do I code it so it fills every time I open the file?
Thanks in advance