Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox not writing value if next selection is same
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox not writing value if next selection is same
I think I'd just clear the dropdown and let the user start from scratch:
Dim drpdwn As DropDown Set drpdwn = ActiveSheet.DropDowns(Application.Caller) With drpdwn Range("b1").End(xlDown).Offset(1, 0).Value = .List(.ListIndex) .listindex = 0 End With End Sub Or maybe you could supply another button near the dropdown. Have them use this to "repeat" the value. Joe Mathis wrote: 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, Joe Dim drpdwn As DropDown Set drpdwn = ActiveSheet.DropDowns(Application.Caller) With drpdwn Range("b1").End(xlDown).Offset(1, 0).Value = .List(.ListIndex) End With End Sub -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart content to change according to a selection on a combobox | Charts and Charting in Excel | |||
ComboBox Selection | Excel Discussion (Misc queries) | |||
fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
How do i populate a text box according to selection in combobox? | Excel Worksheet Functions | |||
Sort Macro: Utilizing ComboBox Selection for Key1 through 3 Ranges | Excel Discussion (Misc queries) |