Stopping Pesky Inputbox

Hello,

I have some code a fellow programmer helped me out with. It does seem to work the way I want. There's just one thing Im trying to stop from happening....I have four options a user can select from in a drop down box. Right now regardless of which one of the four options you select an inputbox is triggered. I only one the input box to be triggered on two of the four options....I cant seem to fix this, was hoping someone might be able to assist. Ive tried using Appplication.EnableEvents = False to stop the inputbox, but for some reason it doesn't stop it.

In the below code the inputbox should NOT popup for Case 1 and 2, they are titled, "Working Remotely" and "Not Required"

thanks in advance!

Please Login or Register  to view this content.

Disregard, problem solved, it was with this line right here:

Please Login or Register  to view this content.

Needed to be changed to:

Please Login or Register  to view this content.

Originally Posted by excelenergy

Hello,

I have some code a fellow programmer helped me out with. It does seem to work the way I want. There's just one thing Im trying to stop from happening....I have four options a user can select from in a drop down box. Right now regardless of which one of the four options you select an inputbox is triggered. I only one the input box to be triggered on two of the four options....I cant seem to fix this, was hoping someone might be able to assist. Ive tried using Appplication.EnableEvents = False to stop the inputbox, but for some reason it doesn't stop it.

In the below code the inputbox should NOT popup for Case 1 and 2, they are titled, "Working Remotely" and "Not Required"

thanks in advance!

Please Login or Register  to view this content.