Hi All,

I could do with a little help involving a problem I have. I need to generate a means of entering data into four cells in adjacent columns. However I need to display a list box that has two columns for each to ensure the right data is entered. Column 1 would be a 3 digit alpha numeric code and column 2 a description to aid the user. The complication is that the columns are part of a larger sheet and once the data values have been entered for the entire row I need to be able to filter by them each respectively or in any combination with any of the other columns on the sheet.

My thoughts so far have been to generate some VB script to open an input form for the four columns when you move to the first affected cell in the row you are working on. The form would display the four list 2 column list boxes allowing you to select the necessary values for each of the 4 columns from the same form. Then you would click next, it would subsequently update the 4 columns in the respective row with the selected values and move to the cell in the next column on the same row. This would be repeated for every subsequent row added except the header.

I relies that access would probably be a simpler place to do this sort of thing although I am restricted to excel for the purposes of this project.

Thanks in advance to any help any of you can give, i appreciate it.

Please forgive any mistakes in etiquette on my part as this is my first time on this forum.

Thanks again.

J.:)

Your suggection for comboboxes is fine, they could easily pick up data from a 2 column RowSource, make sure your combobox has 2 columns and the bound column is 2, this way you get the data and not the code.

I would have the control source as a single row at the top of the sheet and when you click next on the user form it copies this row to the bottom of the table, then update the paste row by one. If you have an autofilter on the table, it should give the results you are after.

Martin