Hi, i have a data validation list in a cell (A1) and when the value in the list is changed, i want the cell next to it to be updated.
e.g. If A1 = "SPN", B1 should say "Yes".
When ever i try to do this, i get a 1004 error.
When it tries to change the value of B1, i get the 1004 error.
Private Sub worksheet_change(ByVal target As Range) if range("A1").value = "SPN" then range("B1").value = "Yes" end if end sub
What am i doing wrong?
submit worksheet please, or at least an example
Hi Typicalalex1,
I have done little modification to your code. As you are using worksheet change, your code posted in post#1 is getting called recursively and hence error. Check the below code.
Private Sub worksheet_change(ByVal target As Range) If target = Range("A1") Then Range("B1").Value = "" If Range("A1").Value = "SPN" Then Range("B1").Value = "Yes" End If End If End Sub
Regards,
Paresh J
Click on "* Add Reputation" as a way to say thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks