Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have three userforms, each with a combobox that I need to populate with
items from the same worksheet. Also each list that populates each combobox has the possibility to increase is number of items. The name of the worksheet the holds all the data is "Items" 1) This is the largest and can probably use a feature I have seen where the command scrolls up to the last empty row. I need to pull item number and item description from "Items". Starting cell for each is A3 and B3 respectfully. Ending cell is unknown due to the possibility of adding new items. However, I will not enter any data having to do with anything else past the end of the list. I only need to populate with the item number but need to be able to place the item number and corresponding item description in the appropriate cells (already have code to place data in cell). 2) Currently, I have station numbers 1-7 in C3-C9. This may be added to if a new EMS station is built, ie station 8 would be in C10. How do you populate a combobox using same row. NOTE: I have data to the right of this list that pertains to another combobox (see #3). 3) Currently I have a list of the ambulance numbers (M1, M2, M4, M7, etc) in a list starting with M3 and listing down the sheet. I am not sure if you can pinpoint that column and still do a command that locates the last empty cell in that column or not. For this example, let's say M3-M20 contains each unit number, with the possibility of adding more. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Populating a combobox | Excel Programming | |||
ComboBox populating problem | Excel Programming | |||
Populating a ComboBox | Excel Programming | |||
Populating combobox/listbox | Excel Programming | |||
Populating ComboBox Methods | Excel Programming |