Run Macro If Cell value = "Other"

  • Thread starter Thread starter bobbly_bob
  • Start date Start date
B

bobbly_bob

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
 
If Range("F4").Value = "Other" Then
Call yourMacro
End If

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run Macro If Cell have "x" value 0
MACRO RUN random percentage and copy of column values 1
Pasting cell contents into a macro 1
Macro to insert a line when a value changes in a range 1
Macro running slow 7
Pasting an object into a cell with a drop down menu 1
Delete Cells on value 5
Swap selected cell values 5

Back
Top