By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,147 Members | 1,788 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,147 IT Pros & Developers. It's quick & easy.

How to prevent pop up message twice

P: 1
Hi Team,

I have a question about a msgbox that pops up twice instead of just one time.
Note:Excel data is refreshing via ODBC connection and validating that sheet.
Kindly help me on this.

VBA code:
Expand|Select|Wrap|Line Numbers
  1. private sub worksheet_calculate()
  2. dim target as range
  3. set target=range("c1")
  4. if not intersect(target,range("c1") is nothing then
  5.   if (thisworkbook.sheets("sheet1").range("a3").value="") then
  6.     msgbox "Error"
  7.   end if
  8. end if
  9. end sub
2 Weeks Ago #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.