Worksheet_Change from a data validation list
Closed
JLeeD
-
Feb 16, 2012 at 12:02 PM
aquarelle Posts 7119 Registration date Saturday April 7, 2007 Status Moderator Last seen October 18, 2022 - Feb 16, 2012 at 12:42 PM
aquarelle Posts 7119 Registration date Saturday April 7, 2007 Status Moderator Last seen October 18, 2022 - Feb 16, 2012 at 12:42 PM
Related:
- Worksheet_Change from a data validation list
- Transfer data from one excel worksheet to another automatically - Guide
- Excel data validation list from table multiple columns - Guide
- Contact number list - Guide
- Digital data transmission - Guide
- Messenger suggested list - Facebook Messenger Forum
1 reply
aquarelle
Posts
7119
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
October 18, 2022
491
Feb 16, 2012 at 12:42 PM
Feb 16, 2012 at 12:42 PM
Hi,
Try something like that (not tested) :
Best regards
"Pour trouver une solution à ses problèmes, il faut s'en donner la peine."
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."