I am very grateful to you sir for sharing your knowledge with us. I found yours while searching for videos explaining how I use combobox priorities. That was all i needed. Greetings from Turkey.
Great video. Is it possible by selecting a name from the list we also can show the RowID or any other cell value from the same record in another desired cell If yes, how? I.e. I also would like to be able to show the State_ID in a separate cell which can be used to pull data from other table/s. Like selecting a customer name from a table, then using the customer ID to see the list of its employees from another table/sheet, like Contact Sheet, or Invoices,.....
As in the example, the linked cell is in H1. You can use that information with VLOOKUP or XLOOKUP to pull in any other data from the source. If you want the cell address of the state, for example, you can do something like =ADDRESS(MATCH(H1,$A$2:$A$52,0)-1,1)
I am very grateful to you sir for sharing your knowledge with us. I found yours while searching for videos explaining how I use combobox priorities. That was all i needed. Greetings from Turkey.
Thanks. I'm glad you find my tutorials useful.
Hi sir, this video of yours is very helpful, it helps a lot, thanks for sharing.
Thanks! Glad you found it useful!
Superb!!!!
Thanks! Glad you liked it!
Sir u have studied a lot Great
Thanks! Glad you liked it!
Thank youuuu!
I'm glad your found it useful!
GREAT
Combo box is powerful true but it does not stick inside a cell which is very important too. You have to design a command like an engineer to make one.
Great video. Is it possible by selecting a name from the list we also can show the RowID or any other cell value from the same record in another desired cell If yes, how? I.e. I also would like to be able to show the State_ID in a separate cell which can be used to pull data from other table/s. Like selecting a customer name from a table, then using the customer ID to see the list of its employees from another table/sheet, like Contact Sheet, or Invoices,.....
As in the example, the linked cell is in H1. You can use that information with VLOOKUP or XLOOKUP to pull in any other data from the source. If you want the cell address of the state, for example, you can do something like =ADDRESS(MATCH(H1,$A$2:$A$52,0)-1,1)
@@ExcelBytes My apologies, I can't locate the file and your training video.
@@mikelennon1078 excel-bytes.com/some-interesting-active-x-combo-box-properties-in-excel/
@@ExcelBytes Thanks for your continued support!