LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Populating a ComboBox in a UserForm I Maycotte[_5_] Excel Programming 2 June 27th 06 06:28 PM
Populating a ComboBox DirInfo Excel Programming 1 March 17th 05 10:03 PM
Populating Combobox Methods Todd Huttenstine[_2_] Excel Programming 10 January 18th 04 10:19 PM
populating a combobox on a worksheet Tim Marsh[_2_] Excel Programming 2 November 3rd 03 12:44 PM


All times are GMT +1. The time now is 11:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"