View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
WLMPilot WLMPilot is offline
external usenet poster
 
Posts: 470
Default Populating a combobox

I have a workbook that contains a sheet (Order) that the user will use to
enter a supply requisition by entering the item number and quantity via a
userform. Another sheet (Items) actually list the item numbers (Col A), and
Description (Col B). NOTE: The first row of this list is row 3. In the
event that new items are added, I did a COUNT to obtain the total number of
items and placed it in M1. Using that number (M1), how can I populate a
Combobox with the item number?

Also, I need to be able to "pull" the matching description for that item
number and place it in the appropriate cell in the Order sheet. If you can
provide me the code on how to pull the correct description, I would greatly
appreciate it. I can get it in the correct cell.

Thanks a million!!!

Les