Tinman | A Java Learning Record Store based on Experience API

After some great assistance from tinman around having multiple images that can be moved over on this questions - Check if nested control is outside parent control range

I have now become stuck on trying to achieve a situation where 3 controls are grouped together and all move when one of them is moved.

I have tried using an array as part of the variable declaration but keep getting 'define' errors.

I have considered using a frame but this then creates a situation where the control would need to be able to move outside of the frame and into the main userform which I feel is more complicated from where I am in terms of code currently.

I saw some information about using tags to move all objects with this tag name but this links to the array variable declaration aspect.

If there was a way to set my 'movableimages.image1' variable to contain multiple images, I think this would resolve my problem I just can't work out a way to do it.

Userform Code

I am reading an Excel file into an ADO Recordset using Microsoft.ACE.OLEDB.12.0. As per snb's excellent article on ADO I have been using a number of filters that work perfectly, all except for the "Ends With" filter, for which I am receiving Error 3001: "Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another". The "Ends With" filter is essentially a wildcard filter, just like one would use in SQL, and the syntax is as follows:

"[FieldName] LIKE '*searchterm'".

Saying that I have tried all combinations of wildcard characters (*, %) with no luck. The microsoft documentation on the Recordset Filter property says the following about the use of the LIKE operator:

"In a LIKE clause, you can use a wildcard at the beginning and end of the pattern. For example, you can use LastName Like 'mit'. Or with LIKE you can use a wildcard only at the end of the pattern. For example, LastName Like 'Smit*'.

The above seems unclear, but I believe that they are saying the following:

Beginning And End: LastName Like 'mit' is legal Begins With: LastName Like 'Smit*' is legal

BUT

End With: LastName Like '*t' Is Illegall???

If that's the case, then I know that an Ends with filter is not possible as one may intuitively think, and I hope someone could provide an alternative solution that will mimic an "Ends With" wildcard filter.

If not, then I hope that someone can point me to what I am missing. All suggestions, ideas, or answers are greatly appreciated.

Below is my code:

I have a working piece of code that looks at a columns value, copies those values, and strips off the 'speed' component string of that value - Turning '200 Mbps' into just '200', etc.

They updated the source data on me and the values are now in three columns - AC, AD, AE instead of just AC now. So values can exist in either column and any row, can be Gbps and Mbps, etc.

At the end of the day, I need the total of the three columns and X number of rows. I have sample data below.

How can I (or can I even) modify this existing code to account for the extra two columns. I am wondering if the Dictionary approach is correct at this point. It was originally added at someone else's suggestion.

I have a string like this one in a jsonb column in my Postgresql database: