Anthony's VBA Forum
Where the knowledge is shared
Menu
Home Page
Forum Index
FAQ
Memberlist
Usergroups
Register
Profile
Messages
Login/Out
Quick Search
Advanced Search
Links
Consulting
Products
Who's Online
[
Administrator
]
[
Moderator
]
Can Validation List Selection Generate MsgBox?
Anthony's VBA Forum Index
->
General Excel VBA
View previous topic
::
View next topic
Author
Message
ejlupien
Joined: 14 Oct 2009
Posts: 1
Location: Ottawa
Posted: Wed Oct 14, 2009 1:13 pm
Post subject: Can Validation List Selection Generate MsgBox?
Does anyone know how to use VBA so that it can generate a msgbox after a value is selected from a validation list in a cell?
I know the following will generate the msgbox when cell A1's value changes ...
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range("A1")) Is Nothing Then
Msgbox " Hello"
End If
End Sub
But that doesn't work if cell A1 contains a validation list.
I tried using another if ... to test for "target.value" but without success.
If anyone knows the answer to this puzzle I would greatly appreciate it.
Thanks,
Erik
Back to top
Display posts from previous:
All Posts
1 Day
7 Days
2 Weeks
1 Month
3 Months
6 Months
1 Year
Oldest First
Newest First
Anthony's VBA Forum Index
->
General Excel VBA
All times are GMT - 4 Hours
Page
1
of
1
Jump to:
Select a forum
Excel VBA
----------------
General Excel VBA
VBA on Finance and Investment
----------------
Option Pricing Models
Portfoilio Optimization
Other Finance Topics
VBA on Statistics
----------------
Probability Distributions
Monte Carlo Simulation
Regression Analysis
Announcement
----------------
Updated News
You
cannot
post new topics in this forum
You
cannot
reply to topics in this forum
You
cannot
edit your posts in this forum
You
cannot
delete your posts in this forum
You
cannot
vote in polls in this forum
Powered by
phpBB
© 2001, 2002 phpBB Group