Hi, I am trying to make a drop down box that auto populates when you start typing the name of what you want. The list needs to be pulled from cells on a different sheet. Can someone help me with the code on this? Thanks
Hi, I am trying to make a drop down box that auto populates when you start typing the name of what you want. The list needs to be pulled from cells on a different sheet. Can someone help me with the code on this? Thanks
Here is what I have. The current code was set up to pull information from the current page it is on, I need it to pull it from the 2nd page and put it in the additives boxes.volumes.xlsm
Do all of the comboboxes on sheet intermediate design/column H (additives)get the same list from sheet names and blends?
Ben Van Johnson
All the combo boxes under additives should show the same list, a2 though a46 on names and blends.
Basically I am trying to figure out how to pull the data for a combo box from another sheet. Is it possible or do I have to have some hidden cells on the same sheet pulling the information?
1. Select sheet "names and blends", sort the Materials column to delete blank rows.
2. Select rom row 2 to the bottom of the list and type a name such as "MaterialsList" in the name box on the formula bar.
3. Select Developer ribbon, Design Mode:
4. For each combobox, right click, select PROPERTIES
a) ListFillRange --> "=materialslist"
b) Linked Cell --> the cell the box is sitting on
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks