Stop macro after 1 application

[parbynat]

If I change J1 to 1 it runs the macro once, if I change it to 1 again it runs the macro again.
What can I add to the code to only allow it to run once.
Something like stop recording_macro if J1=1

Please Login or Register  to view this content.

Thanks

[Keebellah]

Hi, add a value to another cell, for example TRUE or FALSE
When you change th value in the cell to 1 it checks if the value is TRUE (or FALSE) and depending on your choice you can either let it perform the macro or skipt it.
Hope my answers makes sense to you

[vba_php]

What can I add to the code to only allow it to run once.
Something like stop recording_macro if J1=1

more than likely, the answer is:

Please Login or Register  to view this content.

[Keebellah]

If the OP only wants the macro to run ONCE, then this won't work, the moment you change J1 to 0 and then back to 1 ...

[vba_php]

If the OP only wants the macro to run ONCE, then this won't work, the moment you change J1 to 0 and then back to 1 ...

they will get back to us. more than likely, they have no idea what they want. I see this all day long everyday. just wait...

[Keebellah]

True; people have difficulty explaining something to someone in such a manner that it's clear to the reader.
Assumptions are the result and these on their part are killing.
I quit basing my answers on assumptions

[parbynat]

Thanks for the replies

VBA_php, I used your code and I got a compile error, Else without if.

Keebellah, Sorry my know how is low can you break it down a bit for me.

[Keebellah]

I think this is an oops

Please Login or Register  to view this content.

This should do it

[Keebellah]

You still didn't answer if it's a one-time action or not

[vba_php]

get back to Keebellah. if he can't help, then you can ask me. my code works fine. maybe the words have to be on different lines.

[parbynat]

Can you check I got this right Keebellah

Please Login or Register  to view this content.

Yes I want it to work only once

[Keebellah]

Vba_php: your mistake is the exit sub and the else
To answer about the macro, read it yourself, that’s NOT what’ I posted you’re testing J1 = 1 teiceyy

[parbynat]

If the code is correct when I make J1 1 it starts the macro as I want but when I change it 2 it starts the macro again. Also when I use 1 again it also starts the macro.

My aim is to make empty cell J1 1 and for that to start the macro, then if I key in 1 again I want nothing to happen and nothing to happen if I use any other value.

[vba_php]

My aim is to make empty cell J1 1 and for that to start the macro, then if I key in 1 again I want nothing to happen and nothing to happen if I use any other value.

I'm not following what you're saying. I do apologize. I would recommend that you work with Keebellah. an if statement is very basic, but it doesn't sound like that's what you need. good luck.

[parbynat]

Appreciate your time vba_php

I have spent so much time trying to get this to work

I have a button set up also that when pressed works just as I want. If only I could activate that button when a certain cell is of a certain value but I can't and have to go down the road I'm on.

Fun and games using excel when you lack knowledge

[Keebellah]

Please Login or Register  to view this content.