Excel vba Form & Combo Box question

  • Thread starter Thread starter tmb
  • Start date Start date
T

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
 
tmb,

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