I hope somebody is able to help me on this one.
I have a data base in a worksheet which has town names (a2:a22) and the same town names across (b1:u1) Then the range b2:u22 is the km's.
I have manage to put this together in the normal sheet index match, however what I'm now trying to do is put it into a userform.
So in my userform I have 4 comboboxes - cb1 = from cb2 and 3 are via and cb4 is to - So you'll enter townX in cb1 and in the other two via (those two are normally the same) town Y then in cb4 would be town X again to give you a round trip.
What I am wanting it to do is to put the total number of KM's in tb1.
This is some of the code that I have done...also not sure if the code should be on start up or in tb1.
Any help would be great, thanks

Please Login or Register  to view this content.