Yes/No Check box

msjacks · Mar 22nd 2006

I am creating a macro that will run an application.
The spreadsheet will have data input into columns A - L and then the user will hit a button to run the macro.

What I would like to add as a part of this button/macro is a check function.
If Column T has any negative numbers in it, then the user has possibly entered data incorrectly.
I would like to have a box pop saying something to the effect of "negative numbers, is this correct" Then let them choose yes or no etc. If yes, then continue to run the macro. If no then stop the macro.

rmullen · Mar 22nd 2006

Re: Yes/No Check box

Instead of having a yes/no check box, you may just want to do a message box...

Code

If (code to see if Column T has any negative numbers in it) Then


theAnswer = MsgBox("Is Everything Correct?", vbYesNo)


Select Case theAnswer
Case vbYes
...do rest of program
Case vbNo 
         Exit Sub
End Select


Else


Exit Sub

Display More

msjacks · Mar 22nd 2006

Re: Yes/No Check box

Thank you very much. I just found out that the answer should never be yes so I'm going to adjust it so that if there are any negative #'s then a msg box pops up and it exits the sub. But thank you very very much!!

Yes/No Check box

Participate now!

Share