Solved: Array & cbos?

[bopo]

Hi People

Basically I have a cbo which displays 1 to 5, I want to use the number selected and * by something else, basically how to I reference the option (number) selected in a cbo?

[CBrine]

I'm assuming this is a userform?

[VBA]combobox1.text * 5[/VBA]

HTH
Cal

[bopo]

I'm assuming this is a userform?

[vba]combobox1.text * 5[/vba]
HTH
Cal

Hi

Yeah its a userform, For a example a user selects the "3" option from the cbo, this number is then included in some calculation, see what I mean

[lucas]

Just to show it in use Cal:
[VBA]TextBox1.Value = ComboBox1.Value * 5[/VBA]

[bopo]

Just to show it in use Cal:
[vba]TextBox1.Value = ComboBox1.Value * 5[/vba]

I want to use the value within the combo box to multiply the value, example

private sub textbox1_afterupdate()
txttotal = txtcost.text * "value/option selected in the combo box"

the coding probably wont work, however I am just using it as an illustration

[Zack Barresse]

Why wouldn't you use your ComboBox_AfterUpdate event with your TextBox_AfterUpdate? Using them both and using a private sub to run would make things much easier. So when your combobox or your textbox is changed the routine would fire, keeping it much more dynamic.

HTH

[lucas]

[VBA]Private Sub ComboBox1_Change()
TextBox1.Value = ComboBox1.Value * TextBox2.Value
End Sub[/VBA]