Canceling on Input Box

[Slang22]

Hi All,

i don't know anything about VBA, but I was able to locate a VBA script that works to fit my needs. The only thing that does not work is the "Cancel' button that populates on the Input boxes. Can someone help me fill in the gap for this?

----------

Please Login or Register  to view this content.

[Roel Jongman]

After the code for the inputboxes put statements like this
you did not say what you want to happen if cancel is used. so I build to options.

The first line of AgGrp will stop executing the rest of the macro if cancel is pressed.
The second line for RpDate will use the last day of last month as reporting date and continue the macro with that date

Please Login or Register  to view this content.

so it is up to you if that is suitable or that you need other things to happen when cancel is used.

[Keebellah]

Hi, welcome to the forum.
If I understand you correctly you need to test if the user entered something of pressed Cancel?

You will need to add two tests
Firt one is check if AgGrp has been entered

First Dimension ALL your variables

Please Login or Register  to view this content.

What this does is check if anything has been entered, if the user presses X (top right) then it's Canceled and the value is FALSE and this a Boolean (True or False)

If tha type of answer is a Boolean the it's false so it exist the sub

Hope this helps

[Slang22]

You da man Roel!

Thank you Very much.

Thanks, Keebellah!