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.