Combobox not writing value if next selection is same

J

Joe Mathis

Hello

The code I have below works very well to write the value chosen in the combobox to teh appropriate cell in a list. The problem I have is if the value chosen the next time I use the combobox is the same as the previous, nothing will be written. I have tried using an if/then/else to compare the previous cell to the value and using the Range statement below for true and false but it did not work. Can someone please offer some code options

Thank you, Jo

Dim drpdwn As DropDow
Set drpdwn = ActiveSheet.DropDowns(Application.Caller
With drpdw
Range("b1").End(xlDown).Offset(1, 0).Value = .List(.ListIndex
End Wit
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
Drop down list control value in vba 2
Iterating through a ComboBox's values 6
Textbox input goes to 2 sheets in same wbk 0
cancel a combobox change 1
Ensuring Combobox has Value entered if another ComboBox has aspecific value 3
Combobox list based on choice in previous combobox 0
use ComboBox value to select range and then use selected range tocreate a chart 3

Top