VBA script or something else to automatically puch button

[Ruben Schmitz]

Hi,

Is it possible to make a VBA script or something else that automatically pushes a button with a macro in it?

for example, if the cell (1:I) has WAAR in it, that the button (planning maken) is pushed automatically (see image)?

It doesn't have to be this way, if you know something else it's fine too.

Thanks a lot,

Ruben Schmitz

 

[onlyadrafter]

Hello,

Is cell I1 a formula, or manually entered?

 

[Ruben Schmitz]

Hi,

it is a manually entered!

 

[onlyadrafter]

Hello,

try this code in the relevant sheet code window

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "$I$1" And Target.Value = "WAAR" Then
        Application.Run ("YOUR MACRO NAME")
    End If
End Sub

change YOUR MACRO NAME to your planning maken macro name

 

[Ruben Schmitz]

Hi,

I tried the code, but keep getting errors (see the image).

I tried a couple of things but nothing works.

do you know how I can make it work?

RS

 

[Ruben Schmitz]

When I try taking this line out the first Sub-line VBA

Hello,

try this code in the relevant sheet code window

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "$I$1" And Target.Value = "WAAR" Then
        Application.Run ("YOUR MACRO NAME")
    End If
End Sub

change YOUR MACRO NAME to your planning maken macro name

requires me to create a new macro when I try and run it, which then adds that line back in, and I am back to square one.

 

[onlyadrafter]

Hello,

the code doesn't go into a standard module, you need to put it into one of the 'Blad' under Microsoft Excel Objects. The sheet where the WAAR is.

Your own code for the Planning Maken button should be in the Sub Planning_Maken()

Also the Application.Run ("Planning Maken") . should be Application.Run ("Planning_Maken"). It needs to call your already created macro for that button.

 

[Ruben Schmitz]

Hello,

the code doesn't go into a standard module, you need to put it into one of the 'Blad' under Microsoft Excel Objects. The sheet where the WAAR is.

Your own code for the Planning Maken button should be in the Sub Planning_Maken()

Also the Application.Run ("Planning Maken") . should be Application.Run ("Planning_Maken"). It needs to call your already created macro for that button.

Hi,

When I put the code in the sheet and start running the code it asked me to select a macro. Then I click on me macro Planning_maken en start running te macro. then the macro starts running for one time. But it isn't running automatically. When I delete the TRUE ( WAAR is the dutch word for TRUE) and type TRUE in (I;1) nothing happens.

In the second picture, you can see the Marco Planning_maken

 

[Ruben Schmitz]

Hi,

When I put the code in the sheet and start running the code it asked me to select a macro. Then I click on me macro Planning_maken en start running te macro. then the macro starts running for one time. But it isn't running automatically. When I delete the TRUE ( WAAR is the dutch word for TRUE) and type TRUE in (I;1) nothing happens.

In the second picture, you can see the Marco Planning_maken

the Button is form control and not an Active x control