Thanks alot Roy. It worked perfectly.
Posts by xynnn
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