Global Variable

1) where is the above code placed ? It's wise (if not required?) to declare public variables in standard module.
2) is really combobox1 value one of the expected values (does msgbox show?) if not (msgbox shows) you do not have the option to re-assign proper value - just do all activation-related tasks and close form