LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default Validation List Question

I have a data validation list with a number of states in it. Each time I
select a new state I want 2 macros to run. The list is in cell A4 of Sheet
1. Here is the code I am using at the worksheet level, can someone tell me
what I'm doing wrong?

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "A4" Then
pp_maj_macro
pp_minor_macro
End If
End Sub

Thanks so much,
Dave


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Validation list question Gotroots Excel Discussion (Misc queries) 3 December 9th 09 05:16 PM
validation drop down list question [email protected] Excel Worksheet Functions 1 January 22nd 09 03:41 PM
Validation List/Formula Question JWNJ Excel Discussion (Misc queries) 2 February 5th 08 03:18 AM
Data Validation List Question wx4usa Excel Discussion (Misc queries) 1 October 13th 07 04:36 AM
Data Validation-List..Question? maperalia Excel Discussion (Misc queries) 4 July 12th 07 06:37 PM


All times are GMT +1. The time now is 06:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"