VBA Code based on Drop down selection

Hello All,

I am sure this is very simple but it is something I cannot get my head around!

I have one dropdown box, which is built through Data Validation. This list has two options, YES and NO. If YES is selected then I want it to open another document stored on a shared drive. IF NO is selected then nothing should happen.

At the moment I have: (MsgBox is for testing - but it doesn't work)

Please Login or Register  to view this content.

The dropdown is in cell D32 ... Can anybody let me know why the above doesnt work and what I need to change MsgBox from to open a document path?

Thanks,
Chris

Hi -

The only reason I think why it is not working is maybe you're in design mode.

event

Originally Posted by event21

Hi -

The only reason I think why it is not working is maybe you're in design mode.

event

Should this just automatically run when the dropbox in D32 is changed to YES? Or do I need to add the code to a macro? The code is currently just in the VB project .... Which I thought would work as it is on a change event?

Originally Posted by TMS

It's fussy and, in this case, case sensitive:

Please Login or Register  to view this content.

Regards, TMS

Thanks TMS - Still doesn't appear to work though .... unless I am doing something wrong. The worksheet is saved as macro-enabled workbook, that code is in the VB project so when cell D32 is changed to YES, that message box should appear? That's correct isnt it?

Originally Posted by TMS

An event handler needs to be in the Sheet Class Module, not a standard/normal module. Right click on the sheet tab and select View Code. Paste the code there if it is not already there.

I knew it would be something simple! Thanks TMS.

The Message box is now appearing as expected. As for the second part of my query, can this MsgBox be replaced with a location for a source file that will open when YES is selected?