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: 275
Default Help in adding another check to my code

Hi,
I have this code which checks the value in cell A1, if it is not equal to a
certain value then run the Banker macro
If it is the show msg box

If Range("A1").Value = 15 Or Range("A1").Value = 12 Or Range("A1").Value = 9
Or Range("A1").Value = 6 Or Range("A1").Value = 3 Or Range("A1").Value = 0
And Range("ab1").Value = "" Then
MsgBox "Banker!", vbExclamation, "test"

Banker
Else
If IsNumeric(Range("B9")) And Range("B9") 0.5 Or Range("B9").Value = "1p"
Or Range("B9").Value = "10p" Or Range("B9").Value = "50p" Then

MsgBox "Box already picked..chose another !", vbExclamation, "test"


what I want added to the above is a further check to see if cell AB1 is
populated with 1 if it is then run macro Banker2 if it isn't run Banker

hope this makes sense
 
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
Shorten code to apply to all sheets except a few, instead of individually naming them, and later adding to code. Corey Excel Programming 3 December 11th 06 05:14 AM
Adding a Check Mark commant to the Menu TimlmiT Excel Programming 4 June 6th 05 11:15 PM
Adding Check Boxes Mike R Excel Discussion (Misc queries) 2 February 13th 05 03:59 AM
help to speed up adding check box jono1970[_2_] Excel Programming 0 October 24th 04 10:54 PM
help to speed up adding check box jono1970 Excel Programming 3 October 24th 04 10:10 PM


All times are GMT +1. The time now is 11:50 AM.

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

About Us

"It's about Microsoft Excel"