I need procedure to my codes after click button from the second time

[Omar M]

Hi Experts,
I have code ,running the code from the first time but if I click the button again then should call
sub macro1() before running my original code is sub test().
every time save and close the file.
the first time when run my original code will be when open the file .
I hope this clear guys.

 

[Micron]

Declare a module level variable (right at the top of the module, something like Dim bolRan As Boolean).
In your 1st sub near the beginning, test bolRan. If it is false, run first sub. If True, call 2nd sub which will then run. Then execution will continue in 1st sub. I suspect that is what you want. In 1st sub just before it will finish or exit, put bolRan = True. Thus when 1st sub runs first time, bolRan becomes True. Upon second button click, 2nd sub will be called from first sub because bolRan is True.

Next time you open wb, bolRan will be false before first click of command button.

 

[Omar M]

Hi
thanks for guiding me.
to be honest I have no idea to that. I have no expriene to write some lines by vba.
I hope to do that for me if you have free time.

 

[Micron]

You said you already have code. So start by posting that?
Please use code tags for posting code (click VBA button on posting toolbar and paste within the resulting tags).

 

[Omar M]

Hi again !
just I want to know before I post codes, does procedure make difference based on code type, or I can implment for any code?

 

[Micron]

I don't know what you mean by code type. I consider code types to be like VBA, HTML, Perl, Java, Python etc. Surely that is not what you mean.
As long as the code is Excel VBA it should be OK.

 

[Omar M]

let's take simple example:

Sub macro1()
If Range("A1").Value="yes" Then
Range("A2").Value="OMAR"
End If
End Sub

Sub test()

Columns("C:C") = "@"

End Sub

 

[Micron]

I have code

You said you already have code. So start by posting that?

I think you need to post your button click code. That looks totally unrelated to your thread. If I do anything with that, you're probably going to come back and say you can't implement it and make it work.

 

[Omar M]

in OP I said

before running my original code is sub test()

so the button will link with sub test()

That looks totally unrelated to your thread

I don't unerstand how is that?!