PC Review


Reply
Thread Tools Rate Thread

Combo Box_Change

 
 
=?Utf-8?B?UmljaA==?=
Guest
Posts: n/a
 
      8th Nov 2007
Hi,

I have set up a number of combo boxes and am running some _change macros
from them (see code below)

Private Sub Q2_Combo_Change()
Application.EnableEvents = False
If Sheets("Answers").Range("C2") = "Yes" Then MsgBox "Watch list"
Application.EnableEvents = True
End Sub

The combo box data is based on a variable range using an offset function:

=OFFSET(Lookups!$B$2,0,0,COUNTA(Lookups!$B:$B)-1,1)

This is to cover people changing the list in the future and the combo box
needing to auto update the list. For some values in this list, they are on a
watch list. Cell "C2" monitors for combo box output equal to an item on the
watch list. Problem is that when the target cell in "C2" equals "Yes" (based
on the combo box selection) the msg box appears twice.

Any ideas how to make it only appear once?

Rich
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Access 2007 - Combo Boxes to break down list in othe combo box A_Barnes General Software 1 23rd Jul 2011 03:05 PM
combo box selection runs query to sum values in table not gettingparameter from combo box RCGUA Microsoft Access Form Coding 2 23rd Jul 2009 01:32 AM
Filtered list for Combo Box ListFillRange - Nested Combo Boxes =?Utf-8?B?RG9jdG9yRw==?= Microsoft Excel Programming 4 30th Jan 2009 10:18 PM
Open form based on combo box value w/error message for blank combo box Ruth Microsoft Access 0 20th Apr 2007 11:00 PM
Store non-bound combo column as combo's control source? Nick Mirro Microsoft Access Forms 5 1st Sep 2003 03:19 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:52 PM.