Hi, I am trying to do something similar. I would love it if you would be prepared to post what you have already. I have some VB, and some ideas on ranking the hands, but at the moment I am trying to do without VB, and sorting and re-sorting each hand and its comparative rank as each stage of the hand unfold.
So, "Hand 1" gets dealt two suited unpaired cards from 10, J, Q, K and A, giving it a chance of a Royal Flush, as long as there are no other hands with any of the same suited cards in that range, so I will mark a cells nearby as "possible", the cards needed, and the probability based on cards left in the deck.
For each hand I will display the best possible hands at pre-flop, flop, turn and river stages, the cards needed, and the prob of them turning up.
I am concentrating on four hands and a 'hole' (community cards) so that I can cover splits between any of the four hands, but also the four-way split that would occur if the 'hole' produced the best result. I am using tables of 4 * 13 cards to show what cards are available/left at each stage and then re-calculate what each hands needs to get into a winning/splitting position. I am also building lookup tables for the various hands e.g. Royal Flush, Straight Flush, 4 of a kind, Full House, Flush etc. all the way down to a High card.
I realise there are millions of possibilities at the outset, and it is impractical to enter them all in, so I may concentrate on looking at sequences such as open-ended straights, gut-shot straights, threes, two pairs and so on first, and then consider the suits (or the other way round - who knows!)
Anyway, I am tinkering away, and many heads may come up with many ideas and approaches. Adding pictures in place of AC or 1C or 13C (all representing Ace of Clubs) can follow once the calculations are done.
Once, again would love to see what you have managed with two hands and no VB, and would be prepared to swap/share what I have so far.
I look forward to further discussions, if you are up for it.
Best Regards. Quazzy.
