VBA macro Get variable and showing a message

Yuhka — Sat, 16 Nov 2024 20:14:06 GMT

Hello qlikckers, I'm new to qlikview and now learning the macros!

I would like to show two types of messagesbox when clicking buttons.

I can show a messagebox which shows the values input as vTest when clicking Test_01 button.

Then clicking the Test_2 button, I would like to show a messagebox which shows the messages according to the values input as vTest as follows.

vTest = "Tomato" -> message = "Veges"

vTest = others -> message = "Fruits"

Now I'm making some mistakes and my macro doesn't work.

Could anyone tell me if you know.

Thank you for your support!

Re: VBA macro Get variable and showing a message

marcus_sommer — Wed, 21 Aug 2019 07:23:24 GMT

Your specified fieldname of LB_List isn't correct - it's just List.

Beside this what do you want to reach with this kind of macros? Macros should always be the last shot if the needed usability couldn't be applied with any other method - see for this: Macros-are-Bad.

- Marcus

topic Re: VBA macro Get variable and showing a message in QlikView

VBA macro Get variable and showing a message

Re: VBA macro Get variable and showing a message