Good day!
I have a Userform that pulls Number from excel and displays them in textboxes. I would like, within the Userform, to populate another textbox in the form of the largest number from the textboxes.
For example, 3 userform textboxes display #'s
Txt1 = 12 Txt4 = ABC
Txt2 = 37 Txt5 = DEF
Txt3 = 9 Txt 6 = GHI
I need another textbox to look at the textboxes above (1,2,3) and pull the largest number. It should then display the largest number (37 in this example) and another textbox should display the name (DEF) in this example. IF 2 or more of the textboxes are the same, then I need to generate a random number between 1-100 and display the largest result and the winner of that number generation.
Possible?
I have a Userform that pulls Number from excel and displays them in textboxes. I would like, within the Userform, to populate another textbox in the form of the largest number from the textboxes.
For example, 3 userform textboxes display #'s
Txt1 = 12 Txt4 = ABC
Txt2 = 37 Txt5 = DEF
Txt3 = 9 Txt 6 = GHI
I need another textbox to look at the textboxes above (1,2,3) and pull the largest number. It should then display the largest number (37 in this example) and another textbox should display the name (DEF) in this example. IF 2 or more of the textboxes are the same, then I need to generate a random number between 1-100 and display the largest result and the winner of that number generation.
Possible?
