Activate sheet

[Blake 7]

Hi Guys - when i first open the attached workbook - the combo box does not show any values. In order for the values to appear I have to click away from the tab.

I have two bits of code in the workbook. One to create the unique list in the dropdown which is in a module and the second bit in the actual worksheet where the combobox is...

any ideas how to avoid having to click away from the sheet?

Many thanks

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[TMS]

Call the routine from the Workbook Open event as well or instead of the Sheet Activate.

Regards, TMS

[:) Sixthsense :)]

It's working fine for me.

This is what I see when I open your workbook

[Blake 7]

Hi Trevor - many thanks for your suggestion.

Just to be clear ..! are you saying that I should change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

which will then aviod having to click away from the tab? If so I did this but to no avail... sorry if i've missed the point.

Hello, sixthsense... many thanks for your response but I could not view the image but thanks for taking the time to help out. Appreciated.

[TMS]

Put the following code in the ThisWorkbook Class Module. Don't just edit the subroutine header in the Worksheet Class Module.

Please Login or Register  to view this content.

Then it will be loaded when the Workbook is opened. If you leave it in the Worksheet_Activate routine, it will be refreshed every time you move away and back. Not sure of the advantage of that if the list is static.


Regards, TMS

[Blake 7]

Thanks Trevor - I'll check it out now and see how it goes. Cheers mate

[Blake 7]

perfect. thanks trevor - problem solved

[TMS]

You're welcome. Thanks for the rep.