Forum Discussion
Excel searchable combobox
So I created a searchable combo box and was trying to link other combo boxes to it but the input list won't show up in the format controls. I have size, protection, properties, and alt text but no control tab. This is a new computer with new software. I'm not great at excel but have some knowledge of it. What am I doing wrong?
13 Replies
I've been waiting for somebody with knowledge of the Combo Box methodology to respond, but after six hours decided I'd jump in to ask you for a few more details on exactly what you're trying to accomplish.
The reason I'm asking is that with the far simpler Data Validation method, combined with the newly available Dynamic Range functions in some creative ways, I think it's possible to do a lot of things that Combo Boxes used to deliver. Maybe not everything...as I said, I'm not really familiar with them...
But if you can spell out what you're trying to do (i.e., give some examples of what's in the basic or central one; what would be an example of the linked "secondary" boxes, etc., maybe we can come up with a simpler solution.
mathetesthe combo box continues to reduce the options as you type in what you are looking for and each item has a specific item number and unit of issue. Each item is in its own cell and the item number and unit of issue are in adjacent cells in the same row. The combo box works like google search so I need the item number to autopopulate in the appropriate cell.
As I said, the new Dynamic Range functions, with a database, can do some pretty amazing things with drop down boxes. Assuming that the list of things which (to stick with your example) "glove" would elicit is somewhat fixed, changing perhaps on a monthly basis, I would think we could create something that would work. Certainly assuming you routinely start with a finite set of "first words"...
Anyway, let's wait for somebody who knows the ins and outs of Combo Boxes.....
mathetesSo my company has a PDF of all the materials we can order that we need at work. I can search the PDF but I want to just type what I need and have it populate in the form I created. That part works but now I want the adjacent cells to autopopulate with the item number that correlates to it and also the unit of issue i.e. EA, PK, FT...… I'll try to attach a screen shot of my spreadsheet.
Thanks
