Worksheet_Change from a data validation list [Closed]

Question

Worksheet_Change from a data validation list [Closed]

Report

JLeeD - Feb 16, 2012 at 12:02 PM
aquarelle

Posts: 7096
Registration date: Saturday April 7, 2007
Status: Moderator
Last seen: February 22, 2021

- Feb 16, 2012 at 12:42 PM

Hello,

I want my pivots to rebuilt when a value in range("Book_Select") is changed. This range is a drop down data valiation list. What is wrong with my code:

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = Range("book_select") Then
Application.Cursor = xlWait
Call BuildPivots
Application.Cursor = xlDefault
Else
End If

End Sub

Worksheet_Change from a data validation list
Excel data validation list from table multiple columns - How-To - Excel
Combine if statement and data validation - Forum - Excel
Using a data validation AND an IF formula in the same cell ✓ - Forum - Excel
Excel IF statement with Data Validation - Forum - Excel
Excel - Data validation formula - How-To - Excel

1 reply

Ask a question

aquarelle · Answer 1 · 2012-02-16T12:42:08-0500

Answer 1 / 1

aquarelle

Posts: 7096
Registration date: Saturday April 7, 2007
Status: Moderator
Last seen: February 22, 2021

483
Feb 16, 2012 at 12:42 PM

Hi,

Try something like that (not tested) :

Private Sub Worksheet_Change(ByVal Target As Range) 
Dim MyPlage, Cell As Range 
     
Set MyPlage = Range("book_select") 
     
    For Each Cell In MyPlage 
        Application.Cursor = xlWait 
        Call BuildPivots 
        Application.Cursor = xlDefault 
    Next 
End Sub

Best regards
"Pour trouver une solution à ses problèmes, il faut s'en donner la peine."

Worksheet_Change from a data validation list [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!