IF Statements and modules

[nickm84]

Hi,

Hoping someone can help me – I am new to VBA within Excel and hoping to create a script to include IF statements that reference modules I have written (effectively macros).

I want an IF statement to be something similar as follows:

IF cell A2 in worksheet with name “Sheet1” is equal to 1, activate module named “test1”. If not, do nothing.

Hope this makes sense and hope someone can help me create this easily.

Many thanks,

Nick

[Norie]

Nick

You can't really activate modules.

Are you trying to run code that is within subs in the modules?

[nickm84]

Thanks for your reply. I am basically looking to do the following...

In worksheet 1, if cell A2 is equal to one, to turn off calculating cells off automaticlaly in worksheet 2. Then if cell A2 in worksheet 1 is equal to amnything else, not to do anything.

I think I am trying to run code that is written within the modules. As you can tell I am new!

[Norie]

Do you have code?

[nickm84]

Do you have code?

Sadly not. This is what I need help with and to create the IF statement