Run Macro If Cell value = "Other"

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bobbly_bob@hotmail.com - 20 Nov 2006 03:35 GMT

Alright, I have a very simple macro at the moment that unhides a column
and adjusts the print area to suit.

What I need is a maco that will run this macro if the cell F4 = "Other"
from a drop down menu.

Seems painfully simple I just can't find where it is.

Cheers

Reply to this Message

Bob Phillips - 20 Nov 2006 09:42 GMT

If Range("F4").Value = "Other" Then
Call yourMacro
End If

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

> Alright, I have a very simple macro at the moment that unhides a column
> and adjusts the print area to suit.
[quoted text clipped - 5 lines]
>
> Cheers

Reply to this Message