calling a macro in a IF statement

[Potholes]

I have tried to look online and not seems to make sense and unfortunately I don't know
how to code in vba, so I am doing it the long way.

What I would like to know can you call a macro to run within a If statement.

The way I am thinking is something along the lines of,

=if(q6>"",call clear (being the macro) etc etc

[Logit]

.
Paste this in the sheet level module :

Please Login or Register  to view this content.

[Potholes]

Good afternoon logit.

Thank you for that I wish to learn more about VBA so if you would within your code
add a comment line as to just what each line is doing.

I don't quite understand the ( If ME.range ) segment

My macro is called "Clear"

I will not need a message after the macro has run as it will be part of a bigger statement.

Thank you.

[Potholes]

Hi all

I have attached my "Peter" worksheet.

I am going to write some excel if statements to that when a new number is entered in cell "D6" it starts a series of events the first is to run the clear macro first.

ATM, However I am having troubles getting the macro to check and clear cells (H6,H13,J6,J13,L6,L13,Q6)

Logit sent some code but it is not what I was expecting, I did ask for only one cell so that was my fault.

So what I am after is when any digit is entered into Cells D6 or D13 that it first runs the clear macro, ( If possible ).

Pete

[AliGW]

You have a clear button on the page - I would recommend that you use that, as that is what anyone filling out an interface like this would expect (it's usually called RESET). Trying to clear cells as someone starts typing into one of the fields is going to make the macro overly complex, I suspect. You need to employ the KISS principle.

As for combining macros with IF statements, again, I wouldn't muddle functionality, personally, as it will get overly complex.

A slightly more detailed explanation of what you are trying to do with this scenario would help.

[Potholes]

Good Morning Boss Lady of the forum. (Tongue in ckeek)

I sort of figured I was trying to complicate thing, a bit more than a tad.

Regards
Pete

[AliGW]

I am glad you reached that conclusion yourself - progress!

Boos Lady? Well, as far as I am aware, I am the only female mod here at this time.

[Potholes]

NOOOO BOSS Lady not BOOS Lady

[AliGW]

Not enough caffeine yet ... Early here!