Excel vba Form & Combo Box question

[tmb]

I want to show a list of descriptions in a combo box on a form.

When the user makes a selection I want to put an associated data value into
a cell...

My descriptions are in.. A1 thru A5
The corrosponding data are in B1 thru B5
I want the data to go into cell C4

This code will put the description into C4...
Sheet1.Range("C4").Value = cbxCity.Value

I've tried to figgure out how to use the ListIndex property to Offset or
Index but vba doesn'w use Offset and Index like the spreadsheet does.

Can any one give me any help on this??

thanks

tmb

 

[Earl Kiosterud]

tmb,

You can use something like
Range("B1").Offset(RowOffset -1, 0)
or
range("B1").Cells(RowOffset, 0)