I have a sheet with a list of names in column B and their ID numbers in Column A.
I would like to have a second sheet where if I selected a Name in column B (from a combo box) it will automatically select the corrosponding number in column A (in another combo box) and vise versa.
Thanks
Vetequk
Hi,
Are you sure you need two combo boxes?
If you specify range A1:B10 (say) as the RowSource property of a combo box, and set the ColumnCount property to 2, the ColumnWidth property to be 0 ;10 (i.e. hiding the first column), and the BoundColumn property to 1, the value of the combobox will be the value identified by the bound column, i.e. the column A value, and you can then go on to use this.
HTH
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Richard
I have another sheet that uses the ID in a lookup formular. I am looking for a way to validate the date, so the user can either type in a number in column A or the name in column B and the two columns stay synchronised
thanks
Vetequk
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks