Drop down list macro


Posted by Herb B. on January 22, 2002 8:36 AM

I would like to create a macro whereby I could invoke a drop down list from which I could select a value from a list to be input in the current cell. The values for the list box would be stored in the worksheet in a matrix of cells, let's say for sake of argument in a 4x6 arrangement. The drop down list should take on the form of the matrix. Could someone please give me an example of such a macro.

Thanks.



Posted by Joe Was on January 22, 2002 10:52 AM

A dropdown list can be populated from a column of data (Your reference list), but I am not certain that it can be populated from a matrix. I think there must be a one to one correspondence?

You also have a choice of restricting the dropdown to items in the list or not?

If you want such a list let me know and I can send you the inst. JSW