Hi,
I'm wondering if anyone can help. I'm creating a Userfom for the input of Claims but I'm stuck on how to add 2 values from teh combobox dropdowns to an adjacent text box. I'm trying this below but its not working and i'm not sure where to place it?
Its trying to take hours worked in Combobox1 and multiply by the hourly rate in Combobox10 and outputting that result immediately into Textbox1.
Code
TextBox1.Value = Val(Me.ComboBox1.Value) * Val(Me.ComboBox10.Value)
TextBox2.Value = Val(Me.ComboBox2.Value) * Val(Me.ComboBox11.Value)
TextBox3.Value = Val(Me.ComboBox3.Value) * Val(Me.ComboBox12.Value)
TextBox4.Value = Val(Me.ComboBox4.Value) * Val(Me.ComboBox13.Value)
TextBox5.Value = Val(Me.ComboBox5.Value) * Val(Me.ComboBox14.Value)
TextBox6.Value = Val(Me.ComboBox6.Value) * Val(Me.ComboBox15.Value)
TextBox7.Value = Val(Me.ComboBox7.Value) * Val(Me.ComboBox16.Value)
TextBox8.Value = Val(Me.ComboBox8.Value) * Val(Me.ComboBox17.Value)
TextBox9.Value = Val(Me.ComboBox9.Value) * Val(Me.ComboBox18.Value)
Any help would be much appreciated. I can post the full Code if needs be