PDA

View Full Version : Control on Combobox



nagavineela
07-29-2010, 10:49 PM
Hi,
I have 2 comboboxes, 1 - name and 2 is the value
Selecting a name in first combobox should reflect the corresponding value in the 2nd combobox.

Apart from the above query,
I am using exponential function in VBA.
I need to calculate Reliability using a value in txtbox and store the value in another txt box.
How do i set a value in txtbox to be "DOUBLE"

Can anyone help me in resolving this.

Thank you very much.

Regards

Bob Phillips
07-30-2010, 12:51 AM
If ComboBox1.Value = "ABC"Then ComboBox2.Value = "XYZ"

nagavineela
07-30-2010, 01:04 AM
Hi XLD,
The above line of code is not working.
The below are the lines of code i used. Please correct me incase i am going wrong somewhere :
For i = 4 To lastrow - 1
If (cbomodulename.Text = "PM") Then
cbofailurerate.Value = multiply(Range("B" & i).Value, Range("C" & i).Value)
MsgBox cbofailurerate.Value

ElseIf (cbomodulename.Text = "PIM50") Then
cbofailurerate = multiply(Range("B" & i).Value, Range("C" & i).Value)

End If
Next i

Thanks,
Vineela