Ah! Of course. Thanks again for you help. Nothing like a short time frame to
make one forget all the easy stuff... :) Thanks again. You saved me from
creating a lot of sloppy, sloppy code...



--
--jkitzy


"Joel" wrote:

The Controlsource of the Combobox will put the index of the selected item.
You can also fill the combobox with Rowsource ( ListRange if you are using a
box on the worksheet).

"jkitzy" wrote:

Joel,

Thanks! That's terrific. That does let me load the values as desired... I
knew it had to be, like, a couple of simple lines of code!

Any ideas on a short way of reversing the process? So that when I make a
change, I don't have to have code to write the new value in each cell?

For instance, when I change the value of f001, I want it to write the new
value to myCust, 1. Ditto f050. BUT, I'd rather not put code into each
AfterUpdate event. I know I could put an update button, and that may be the
solution, but if I can automate it without the data-entry user pressing a
button, that'd be preferable.


--
--jkitzy