Set textboxvalue = 1 if a product is selected from cbobox

[espenskeie]

Hi

I have a long list of products in a userform. I can choose what product from a combobox, and then at the same line I can choose the ammount of these products, in a textbox that at the same time is hooked up with a spinbutton.

Is there a code that I can add such that if one choose a product it will automatically show 1 in the ammount text box?

Regards
Espen

 

[tlowry]

Private Sub ListBox1_Click()
Me.TextBox1.Value = 1
End Sub

 

[espenskeie]

Thank you!