Hi folks, I'm back, which means once again I am relearning everything I forgot. THANK-YOU for still being here to help!
I am working with an ActiveX Combobox on a Worksheet. On the same worksheet is a named table (A table in the formal Insert:Table sense). I made it a table so it would dynamically expand as records were added to it. There are perhaps 20 - 30 fields per record. The purpose of the combobox is so the user could type in enough information to display possible records that they were looking for, display a number of fields so the user could select which one specifically, which then populates other cells with that record's info on several subsequent sheets.
I would have been really happy if I could just put the name of the table in the listfillrange property like you can do with any collection of cells which you have named, but nooooooooooooo.
Why not?
Is there a way to do this or need I handle this in another manner entirely?
I feel stupid and humbled, once again. Ain't the first time and unless I die now it won't be the last on this earth-
Thank-you!
I am working with an ActiveX Combobox on a Worksheet. On the same worksheet is a named table (A table in the formal Insert:Table sense). I made it a table so it would dynamically expand as records were added to it. There are perhaps 20 - 30 fields per record. The purpose of the combobox is so the user could type in enough information to display possible records that they were looking for, display a number of fields so the user could select which one specifically, which then populates other cells with that record's info on several subsequent sheets.
I would have been really happy if I could just put the name of the table in the listfillrange property like you can do with any collection of cells which you have named, but nooooooooooooo.
Why not?
Is there a way to do this or need I handle this in another manner entirely?
I feel stupid and humbled, once again. Ain't the first time and unless I die now it won't be the last on this earth-
Thank-you!