Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox vs Combobox
For some reason, I am having a hard time grasping the difference between
listbox and combobox. I am new to macros in excel. I am creating an order entry via excel using userforms. Here is the background of it: Worksheet(Order) = Sheet that userforms are utilized to input data in order to create supply request for each ambulance station. Worksheet (Items) Column A = Item Number, beginning with A4 Column B = Item description, beginning with B4 Column C-? = Max stock levels for each Ambulance base. Cells C2-I2 (currently have 7 stations, hence ? in above line) = Station Number (1-7) Looks like this: A B C D E F G H I 1 2 1 2 3 4 5 6 7 3 4 101 Nasal Cannula 5 10 5 5 5 5 5 (list continues down to list all stock items available) Here are the three different ways I need to create a Listbox or combobox. NOTE: User will enter only an Item number and Qty. 1) Need to create listbox or combobox that list all item numbers on "Items" so that the user can ONLY enter a valid item number within the list. Once this is done, I need to pull the item description and max stock level for the appropriate station. User previously entered Station# in B1 of "Order" sheet. 2) Create a listbox/combobox that pulls the station numbers in so that user can only enter a valid station number. Currently C2 - I2. If a new station is built the supply officer will add the column for new station in column J along with the station number (J2). Code needs to pick up new station number automatically. NOTE: this may not be the last column that has data within sheet "Items" 3) In Column S, row 1-20, I have each ambulance number (M1, M2, M3, etc). Need to pull this into a listbox/combobox) for user to choose which ambulance get narcotics if needed. Thanks for you help!!! Les |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
comboBox vs Listbox | Excel Programming | |||
Combobox v Listbox | New Users to Excel | |||
Combobox/listbox | Excel Discussion (Misc queries) | |||
ComboBox & ListBox problem | Excel Programming | |||
Combobox or Listbox | Excel Programming |