looking up values in a csv file to place in a list box
Posted by steven scaife on September 20, 2001 5:21 AM
I have a userform that when an item is selected populates 4 fileds in a row. What i have done is copied the data froma csv and pasted into a new worksheet in the current document. When the data changes i have to continually cut and paste the new data into the worksheet. is there any way to access the csv files information and link it to the listbox on my form. In the list box properties under the rowsource i am using the following :
"=stocklist!a2:g157" do i have to change this statement. I'm not sure how to reference other spreadsheet documents i only know how to access the sheets in the current document.
any help would be gratefully accepted