Assigning a macro to a specific cell

[Kevin Knight]

Can anybody help me?

I have a cell which is linked to a data validation source. The options available are a range of numbers, and then finally 'Other'.

What I'm looking to do is for a macro to run when the option 'Other' is chosen.

This macro would then unhide a selection on the same worksheet, that at other times would remain hidden.

I'm sure there must be a way, but I can't work out how to do it.

Thanks
Kevin

[teylyn]

Hello,

a macro along these lines, maybe?

Please Login or Register  to view this content.

Change the A1 to the cell you want to monitor. Adjust the section you want to unhide.

cheers,

-------------

Worksheet event code is stored on a worksheet module. To add it to your worksheet, do the following:

Copy the code
Select the worksheet in which you want the code to run
Right click on the sheet tab and choose View Code, to open the Visual Basic Editor.
Where the cursor is flashing, choose Edit | Paste

[Kevin Knight]

Hi teylyn,

Works perfectly thanks.

Is it also possible to reverse this when they alter the selection from 'Other' to a number in the drop down list?

[teylyn]

Sure, something like

Please Login or Register  to view this content.

[Kevin Knight]

Perfect!! Happy days!