topic Re: VBA Macro in QlikView

VBA Macro

Yuhka — Sat, 16 Nov 2024 02:42:38 GMT

Hello everyone, I'm new to qlikview and VBA macro.

I have an issue with VBA macro on my qvw.

Using macro, I would like to

get the values on the text object (TX01)
showing error message in case the text="0"

Now I can get the text but can't show the message. It seems the macro doesn't work.

Sub Check
msg = "not selected"
set i = ActiveDocument.GetSheetObject("TX01").text
if i="0" then
MsgBox(msg)
end if
end Sub

I would make some mistakes on my expression, please help me.

Thank you for your support.

Re: VBA Macro

Frank_Hartmann — Mon, 19 Aug 2019 09:09:13 GMT

try this:

Sub Check msg = "not selected" set mytextbox = ActiveDocument.GetSheetObject("TX01") i = mytextbox.getText if i="0" then MsgBox(msg) else Msgbox(i) end if end Sub

Re: VBA Macro

Yuhka — Mon, 19 Aug 2019 09:20:33 GMT

@Frank_Hartmann san,

Thank you for your quick reply.

It worked perfectly!

Re: VBA Macro

Claudiu_Anghelescu — Mon, 19 Aug 2019 11:21:57 GMT

set i = ActiveDocument.GetSheetObject("TX01")