traveler7739
10-23-2010, 05:51 AM
Hello Everyone,
I'm new to VBA code and have a small issue I need help resolving. I have two cells on a user spreadsheet both with data validation drop down lists. I would like the second cell to auto fill if a certain value is selected in the first cell. This is the simple line of code that I wrote to accomplish this:
Sub WidgetInput()
If Range("Input1") = "Item1" Then Range("Input2") = "Widget"
End Sub
How do I change this code so that cell 2 fills with "Widget" automatically when a user selects "Item1" in cell 1?
Thank you very much!!
I'm new to VBA code and have a small issue I need help resolving. I have two cells on a user spreadsheet both with data validation drop down lists. I would like the second cell to auto fill if a certain value is selected in the first cell. This is the simple line of code that I wrote to accomplish this:
Sub WidgetInput()
If Range("Input1") = "Item1" Then Range("Input2") = "Widget"
End Sub
How do I change this code so that cell 2 fills with "Widget" automatically when a user selects "Item1" in cell 1?
Thank you very much!!