Is it possible to run averages on a userform?

[MFish]

Hi,

Is it possible to calculate averages on a userform with TextBoxes/Comboboxes?
Example:

Combobox1.additem = "50%"

combobox2.additem = "100%"

Maybe...? Lol

Textbox1.value = combobox1.average + combobox2.average

Visually it would say within Textbox1
75%

So, before I hit submit on the userform and put it down on cells A1-A3, I can see the calculation.

 

[MFish]

Hi,

Is it possible to calculate averages on a userform with TextBoxes/Comboboxes?
Example:

Combobox1.additem = "50%"

combobox2.additem = "100%"

Maybe...? Lol

Textbox1.value = combobox1.average + combobox2.average

Visually it would say within Textbox1
75%

So, before I hit submit on the userform and put it down on cells A1-A3, I can see the calculation.

Ok, I figured out something...

I can use, let's say, 3 textboxes...

Textbox3 is the one I want to show the average of the other 2 inputs. Code goes:

Sub textbox3_Change()

textbox3.value = (Textbox1.value + Textbox2.value) /2

End Sub

If I type in 10 in textbox1 and 6 in textbox2, I should get a value returned back in textbox3 as 8, but it doesn't. Why?

 

[DanteAmor]

Try with this

Sub textbox1_Change()
textbox3.value = (Textbox1.value + Textbox2.value) /2
End Sub

Sub textbox2_Change()
textbox3.value = (Textbox1.value + Textbox2.value) /2
End Sub

 

[MFish]

This works better... But, issue with the value returning in Textbox3 is it's taking the individual number from textbox1 and textbox2, respectively and dividing it by 2. It doesn't add the two together and THEN take the average.
If textbox1 is 10 and textbox2 is 20 the value it returns in textbox3 is literally, 510... "5 from the 10 divided by 2" and "10 from the 20 divided by 2".

 

[DanteAmor]

This works better... But, issue with the value returning in Textbox3 is it's taking the individual number from textbox1 and textbox2, respectively and dividing it by 2. It doesn't add the two together and THEN take the average.
If textbox1 is 10 and textbox2 is 20 the value it returns in textbox3 is literally, 510... "5 from the 10 divided by 2" and "10 from the 20 divided by 2".

textbox3.value = (val(Textbox1.value) + val(Textbox2.value)) /2