Finding minimum value in textboxes in userform

[king05]

Hi,
I'm trying to find the minimum value in textboxes while ignoring the blanks.
Textboxes are name D1,D2,D3...D9 and the result should be displayed in D10.
I have used this formula below but it does not show any value.
D10 = Application.WorksheetFunction.Min(D1, D2, D3, D4, D5, D6, D7, D8, D9)
Is there any method to ignore blank textbox using the code above?


Thanks!

[mikerickson]

Try this.

Please Login or Register  to view this content.

[king05]

Thanks mikerickson,
It worked!

Is there any way also to use the same coding in finding the median and max value?

[mikerickson]

Try

Please Login or Register  to view this content.

The loop is needed to convert numeric entries into numbers.

[king05]

Thank you mikerickson!
It's perfectly working now.
Here's the pic of my current project using this code below for future ref of others.
Median.jpg

Please Login or Register  to view this content.