Hi Jennifer
The task seems pretty straightforward, you could send the workbook or supply
the worksheet references to the following

The worksheet range containing the market names (IDs), and the worksheet
range containing the three columns to list in the list box.
I presume you require the changes made to the list box entry to be placed
back into the same place on the worksheet? This may not be good practice
without some validation - do you know what that should be?

The method I normally use to manage changes like this is allow the user to
double-click the list entry, which opens an editor panel to allow changes to
be made, these can then be validated before being written as a new item in
the list. The old (now edited item is marked for deletion) - the 'deleted'
items are not listed again but allow the administrator to validate changes
and if required remove them.

HTH
--
Cheers
Nigel <remove xxnospamxx from address to mail me



"Jennifer" wrote in message
...
Hey my very smart friends,
i have alist box question i have asked a few times and I just can't ever
seem to get the answers to work. Is there anyone out there in a totally
generous mood who would mind me sending them a totally generic workbook
and
they show me how to fill this stupid thing the way I need it filled in a
user
form?
1.User open a user form
2.From a combo box (ComboBox1) choose a Farmers Market ID (lets say they
choose Beverly Hills)
3. The list box is then populated with three columns from the worksheet
(Sheet1) that has info about:
Date Boxes Taken Fruit Variety Etc.

The list box would only populate with info that pertained to beverly hills
of coarse.
Lastly if they change the info in the list box will it then be reflected
in
the worksheet? Thank you guys. Jennifer
--
Though daily learning, I LOVE EXCEL!
Jennifer