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:
Dim nom(0 To 20) As String
For i = 0 To 20
If IsEmpty(nom(i)) = False Then
message = message + "-->" + nom(i)
Else
End If
Next i
Msgbox message
How can I solve this problem ?
Thank you in advance for your help.
Bookmarks