Sort 3 textboxes to get an order for a specific formula

Hi,
I'm fairly new to VBA programming and I stumbled upon a problem concerning sorting my data from textboxes from small to big and use them in a formula to calculate the girth of a box. (Girth formula is [(adding 2 smallest dimension)*2+largest dimension])

The problem is, I keep having an error sorting my data before i can even use this formula. What I have now is:

Please Login or Register  to view this content.

Thanks for helping. I've already been searching for this for about a week at the moment (and about 1 day on this forum).

Couple things:

• Small1 2 and 3 are not objects, and therefore don't have .Values
• AFAIK, .Small is a WorksheetFunction, not Application
• .Small requires that you pass in an array
• You don't want to use quotes around W, D, and H. Using quotes means they are strings (i.e. you're trying to pass in the letter W, instead of the value that W represents)
• I don't see a point in Dim'ing your variables as Variant, they are going to be that by default.

Try:

Please Login or Register  to view this content.

I'm guessing that text boxes 39 to 40 .Values are probably strings. Try to cast them as longs.

Please Login or Register  to view this content.