May 05 2021 10:16 AM
Good day Everyone,
I want to create a combo box then I want it to appear (show) in B1 when Cell A1 have the letter M in it.
When the letter M is not in A1 I want the combo box to be hidden, and would like to use B1 as normal text
If there is an M in A1 and the box appears in B1 - when I select something I want a to use xlookup in B2 with the lookup value in the combo box, is this possible?