Add custom code when 'Change variable values' button is pressed

[former_member182374]

Hello Experts,

Is it possible to add custom code (VBA) when 'Change variable values' button is pressed?

If yes, how can I do that?

Regards,

Omri

[Former Member · Accepted solution]

Hello Omri,

In Common module there's Sub MenuRefreshVariables which can be used.

Sub MenuRefreshVariables()

  On Error Resume Next

  MsgBox "before"

  Dim lCMD As String

  lCMD = pAddin.ExcelInterface.cCMDRefreshVariables

  Call pAddin.ExcelInterface.ProcessBExMenuCommand(lCMD)

  MsgBox "after"

End Sub

BR

Ondrej

[former_member182374 · Accepted solution]

Hi Ondrej,

I see that the changes is on the bex xla file.

Does it affect all workbooks or just the workbook that I'm working on?

Regards,

Omri

[Former Member · Accepted solution]

It affects only current workbook.

BR

Ondrej

[former_member182374 · Accepted solution]

Thanks