Hi,
Thanks for that clarification. I am using a Form control combo box. I
wouldn't know how to write it, but what I would want to program was every
time the combo box changed values, Excel would find the appropriate data
based on the selection contained in the separate worksheet and fill in some
cells. Any direction from here?