Hi Tom,

Again THANKS SO MUCH for your help. Got it working now. My next task
today is to develop a listbox or ComboBox that then links to a VLookup
table in the same workbook on another sheet. I remember glimpsing some
coding in my search for text box coding. Any hints on this or where to
look?

I will dilligently be searching for this coding this morning. Just for
a background I have been given a project to create a combination
Purchase Order/Accounts Payable Voucher workbook where the purchasing
agent fills in most of the information on the Purchase order and it
links to fields in the AP Voucher. Lots of pick lists and VLookup tables
which I can do, but they would like it automated with a Userform to help
the fill-in process. Hence my struggles... particularly seeing I an a
rank VB beginner. So thanks for your patience:-)

Shauna


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!