VBA macro Get variable and showing a message

[Yuhka]

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!

[marcus_sommer · Accepted solution]

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