Welcome to the forum!

You can use Split() to parse the string into an array. You can use Ubound(Split(theString, ";")) to find the number of elements that were split. Since Split() returns a 0 based string array, UBound() would return 2 for the upper bound of the array elements for your example.