Displaying label from a userform combobox selection

Hi,

I am just starting out with VBA and would like to know how to write a code that will display information in a Label (label4) depending on what is selected from a combo box (combobox1) - I have defined the combobox range using its properties settings.

For example the combo box contains text in range A1:A40. If A10 is selected in the combobox I would like to populate label4 with the text contained in the column adjacent, B10.

I Think I need to use the offset command but is im new to VBA and programming in general I need a helping hand with writing the code.

Any help is very gratefully recieved.

Many Thanks,
Pete.

Thanks for that - I made the following ammendments to get it to work for me (and changed the label to a textbox).

Private Sub Combobox1_Change()
If Combobox1.ListIndex <> -1 Then
Textbox1 = Range("B" & Combobox1.ListIndex+2).Value
End If
End Sub

I needed the contents from row B, not sure why I had to use +2 for the listindex but this does work - can you explain the logic? (now displays the text in the column one to the right of the combobox selection.

Also the wordwrap wont work for the text box. I have added
private Sub TextBox1_Change()
TextBox1.WordWrap = True
End Sub

I have also made sure that word wrap is enabled in the spreadsheet and textbox properties - any ideas?