Hi all,
My problem is that I defined a column as drop down list (by using
validation).
My problem is that I want that the data that will be placed in the drop
down list will be taken from a file which I will be open in the
function "Workbook_Open".

I need each cell in the column to be defined as drop down list, so this
is why I used validation.
I don't know before I open the specific file which data will be in the
drop down list.

I didn't find any way to access to these dropdown list and to insert
data to it from VB.

If you have any other ideas how to achieve ny goal in another way, I
will be happy to hear.
thanxs.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/