into this combo box i need to put in a group of cells from A5 to D39 how do i do this without only getting the first column that i selected( i am using combo box from the forms menu)
Ben

Your best bet is probably going to be concatenating those cells.

In column E add the following formula:

=A5&" "&B5&" "&C5&" "&D5

and copy down.

Now set the ComboBox's Input Range to E5:E39.

You can also hide A or E if necessary.

Hope that helps,

Smitty

yeh thanx thats one way to do it