Auto Change text Box depending on ComboBox selection 1

[2ks]

Can anyone tell me how I can get VBA to automatically return a value in a textbox depending on 5 choices in a combo box.

Thanks

 

[ClulessChris]

Select case on the combobox using the change event.

Never knock on Death's door: ring the bell and run away! Death really hates that!

 

[2ks]

So I guess this starts

Sub Combox1_Change()

But how do I get it to change the textbox depending on value selected.

Cheers

 

[ClulessChris]

Something like:

Private Sub ComboBox1_Change()
    Select Case ComboBox.Value
    Case value1
        TextBox.Value = value1
        
    Case Value2
        TextBox.Value = Value2
        
    End Select
End Sub

Never knock on Death's door: ring the bell and run away! Death really hates that!

 

[2ks]

Excellent and tweaked to suit with perfect results.

Simple I guess when you know how. daft thing is done far more complicated things before