Loop through vba array until empty value

[bryvba]

Hello Everyone!

I am having a problem with my VBA code. I have an array in which I put some values and would like to loop through it until the empty value and then displays it in a message box however my code does not seem to work as it displays all values even the empty ones. So I get something like "my message -->apple--> orange--> --> --> -->..."
The function IsEmpty does not seem to work here.

Here is my code:

Please Login or Register  to view this content.

How can I solve this problem ?
Thank you in advance for your help.

[JBeaucaire]

Maybe:

Please Login or Register  to view this content.

[bryvba]

Great! It is working very well!

Thank you very much for your quick reply!

[JBeaucaire]

As it appears you've reached a conclusion, I've marked this thread SOLVED for you.
FYI, this is done through the Thread Tools located above the first post in this thread. Thanks.