Create Combo Box and hide or show based on cell

%3CLINGO-SUB%20id%3D%22lingo-sub-2327620%22%20slang%3D%22en-US%22%3ECreate%20Combo%20Box%20and%20hide%20or%20show%20based%20on%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2327620%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20day%20Everyone%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20create%20a%20combo%20box%20then%20I%20want%20it%20to%20appear%20(show)%20in%20B1%20when%20Cell%20A1%20have%20the%20letter%20M%20in%20it.%3C%2FP%3E%3CP%3EWhen%20the%20letter%20M%20is%20not%20in%20A1%20I%20want%20the%20combo%20box%20to%20be%20hidden%2C%20and%20would%20like%20to%20use%20B1%20as%20normal%20text%3C%2FP%3E%3CP%3EIf%20there%20is%20an%20M%20in%20A1%20and%20the%20box%20appears%20in%20B1%20-%20when%20I%20select%20something%20I%20want%20a%20to%20use%20xlookup%20in%26nbsp%3B%20B2%20with%20the%20lookup%20value%20in%20the%20combo%20box%2C%20is%20this%20possible%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2327620%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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?

0 Replies