Input two cells with one selection
 

Hi,

I have an Access database with a form that has an entry with a drop down
list attached to it. The list has two columns in it. When you select
one of the options from the list it populates one field with the first
column and another field with the second.

Is there a way in Excel to do the same thing?

I have the two columns set up as a range already, but can't get it to work.

Any suggestions?

Thanks

Keith

Input two cells with one selection
 

maybe this...

check out these properties of a combo:
..ColumnCount = 'int value
..BoundColumn = 'int value



Hi,

I have an Access database with a form that has an entry with a drop down
list attached to it. The list has two columns in it. When you select one
of the options from the list it populates one field with the first column
and another field with the second.

Is there a way in Excel to do the same thing?

I have the two columns set up as a range already, but can't get it to
work.

Any suggestions?

Thanks

Keith

Input two cells with one selection
 

Sigh,

this sounds like bad database design, but here we go..

First pls provide additional info.

Do you want to edit on the sheet or use a userform like in Access?

DM Unseen

Input two cells with one selection
 

Private Sub Combobox1_Click()
Range("A1").Value = Combobox1.List(Combobox1.ListIndex,0)
Range("A1").Offset(0,1).Value = Combobox1.List(Combobox1.ListIndex,1)
End Sub

--
Regards,
Tom Ogilvy


"Keith" wrote in message
...
Hi,

I have an Access database with a form that has an entry with a drop down
list attached to it. The list has two columns in it. When you select
one of the options from the list it populates one field with the first
column and another field with the second.

Is there a way in Excel to do the same thing?

I have the two columns set up as a range already, but can't get it to
work.

Any suggestions?

Thanks

Keith

Input two cells with one selection
 

Keith,

Do you want to edit the sheet or create a userform
BTW this sounds like a dependent column, which is bad database design.

DM Unseen