gopal baheti
New Member
- Joined
- Dec 2, 2014
- Messages
- 34
My Code
When I select an item from drop down it clears combobox
Please suggest correction.
Regards
VBA Code:
Private Sub ComboBox1_Change()
If Len(ComboBox1.Value) > 0 Then
Sheets("MASTER").Range("B1") = ComboBox1.Value
With ActiveWorkbook.Names("NAME")
.Name = "NAME"
.RefersToR1C1 = "=MASTER!R2C4:R" & Sheets("MASTER").Range("c1").Value & "C4"
End With
ComboBox1.RowSource = "NAME"
ComboBox1.DropDown
Else
End If
End Sub
When I select an item from drop down it clears combobox
Please suggest correction.
Regards