Load Userform help

[spciii]

Hi all, thanks in advance for helping out this noob.

I am trying to load a userform (named "OpenSpecPairForm) with an If statement, which works fine once as long as the pertinent listbox selection (which is 2) is already loaded. When I return to Excel, select another listbox item, then run the macro, the OpenSpecPair userform does not appear, which is what I expect. But when I subsequently make listbox selection 2, the userform does not load. How can I keep the macro on the lookout for listbox selection 2?
Code is below :

Please Login or Register  to view this content.

Thanks,
spciii

[MaczaQ]

1. take few minutes for read forum rules
2. use code tags
3. attach your workbook

[spciii]

See above. Thank you for the warm welcome.
spciii

[spciii]

Any help with this would be appreciated. I've considered a Do While as long as the sheet is active, but I'm wondering if there is a cleaner way to do it.
spciii

[royUK]

I've attached the macro to the combobox

[spciii]

Thanks Roy!
spciii

[royUK]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save