ComboBoxes and ListFiillRange

[brucemc777]

Having to reacquaint myself with comboboxes and I find myself stumbling on basics.

My first discovery that confuses me is that it appears the only combobox that allows for autofill (search as you type) is the ActiveX version. Is this right? I had been trying to steer away from any ActiveX involvement as I noted cautions when using them on worksheets.

The next problem is proper naming for the ListFillRange. On another sheet, same workbook, I have a table. If I try to reference a column of values in that table in any method other than SheetName!A3:A250, it simply disappears. For instance, tablename[column name] or more exact MasterSchedule[Names]. What am I running into? Any pointers to a reliable, concise refresher on comboboxes?

Later I intend to feed the item selection combobox from another selection process, and I am hoping to simply use a validation drop down of three or four items, so I need to get my work with the combobox that is doing all the work down right first.

Thank-you!

[G e r a r d]

Is this what you are looking for
Fill ComboBox with range on other sheet:

Please Login or Register  to view this content.

clear the list:

Please Login or Register  to view this content.

[Norie]

brucemc777

tablename[column name] isn't a range.

[brucemc777]

Well, I guess to sort it out...

On one sheet I have a table. I want to use a column from that table as my range. As you probably know, if I try to name that range within the table in the Name Box (probably an actual name for it other than what I am making up), the name simply disappears when I press enter after typing it in. I presumed that this was because I am violating a rule dealing with attempting to name a portion of a table, so I am looking for some other method. I could stipulate the cell range, but I doubt that would dynamically resize if I added to (or deleted from) the main table. So that is what I want to achieve in what I am doing, and I also want to learn the can's and can-not's of dealing with this situation.

Thank-you!

P.S. And time-allowing I will get the example up that is causing me trouble in using "FIND" that forced me to work around using "Match" in my VBA, as I really need to understand that one also!)

[G e r a r d]

You can make it dynamically by not putting anny text or value under the cells that contain the items that you want to fill with.
Now you can determine last item and create the (dynamic) range.

[Norie]

You aren't violating anything to do with tables, if you are violating anything it's using something that isn't a range reference for ListFillRange

If you do want to populate using a table you could easily do it in code.

PS A common problem with VBA Find is ommitting arguments.
When you do that the missing arguments take their values from the previous Find which VBA has kindly remembered.