Toggle "STAR" to "DELTA" in Command Button Using VBA

FactoryTalk 32 would be a better platform for doing this sort of thing than Excel.

Change the package.

There is something wrong with your code, post or as on a programming forum.

(check in the code of the button if the appropriate functions are called)

Invoke debugger and watch the code algorithms execute then correct the error.

If you cannot understand it, post the algoritms and someone can help you.

My VBA Code is:

Initially CommandButton1.caption="STAR"

Private Sub CommandButton1_Click()

If CommandButton1.Caption="STAR" then

CommandButton1.Caption="DELTA"

ComboBox1.visible=False

End if

If CommandButton1.Caption="DELTA" then

CommandButton1.Caption="STAR"

ComboBox1.visible=TRUE

End if

End Sub

Is this the copied code?

I always use these "{" after an if

In C++

if (test)

{

blalalala

}

I don't know VBA but in C++ without brackets only the line after the if statement is checked, also True or TRUE?

Also seeing this code the box caption should not change (or only briefly) because in the next if statement it would change it right back.

I solve the problem.

thanks

You should try using elseif in the middle part of the code instead of end if.

Elseif CommandButton1.Caption="DELTA" then