Posts by xynnn

xynnn · Dec 8th 2020

Thanks alot Roy. It worked perfectly.

xynnn · Dec 7th 2020

Hi everyone,

I need help with this code to show ComboBox1 if Cell selected is within Column C or ComboBox 2 if Cell selected is inside Column D. The ComboBox1 keeps appearing in all cells with the code below. Any help is greatly appreciated. Thanks!

Code

   If Selection.Count = 1 Then
        If Not Intersect(Target, Range("D:D")) Is Nothing Then
            Sheet1.ComboBox2.Visible = True
           Sheet1.ComboBox2.Activate
             Sheet1.ComboBox2.Value = ""
        ElseIf Not Intersect(Target, Range("C:C")) Is Nothing Then
            Sheet1.ComboBox1.Visible = True
           Sheet1.ComboBox1.Activate
             Sheet1.ComboBox1.Value = ""
       End If
    End If

Display More

Posts by xynnn

Show Specific ComboBox Depending on Intersect

Show Specific ComboBox Depending on Intersect