Previous Topic Next Topic

Need help with excel message pop up

Solved/Closed
dave - May 5, 2010 at 03:23 PM
 Trowa - May 6, 2010 at 09:43 AM
I need Excel VB help to show a message pop up box to display whenever the value is below 10 or greater then 50 that's also not a multiple of 5

Related:

3 responses

Answer 1 / 3
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 5, 2010 at 04:40 PM
you need help with msgbox or the if statement ?
Answer 2 / 3
dave
May 5, 2010 at 05:04 PM
I don't know what would easier. I basically want only certain values to be valid in a specific field. And if an incorrect value is added a message to display
Answer 3 / 3
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 6, 2010 at 07:07 AM
Is it for data validation ? By this I mean do you want prevent user to type in any thing that is less than 10 or have any thing greater than 50 which is not a multiple of 5
Trowa
May 6, 2010 at 08:37 AM
Hi Rizvisa,

I was just checking the forum and came to this post. I'm curious how you would apply data validation with two statements: only allow a number between 10 and 50 which isn't divisible by 5.

Best regards,
Trowa
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 6, 2010 at 09:13 AM
Hey Trowa. how that graph thing is coming up.

This work for me for the original question, in the validation I have this formula

=IF(A1="",TRUE,IF(OR(A1<10,AND(A1>50,MOD(A1,5)<>0)),FALSE,TRUE))

it allows if data is either "", or is >10 and <50 or is >50 but is a multiple of 5


For your question to only allow a value between 10 and 50 when it is not divisible by 5
=IF(A1="",TRUE,IF(OR(A1<10, A1>50, MOD(A1,5)=0),FALSE,TRUE))

or this
=NOT(AND(A1<>"",OR(A1<10,A1>50,MOD(A1,5)=0)))
Trowa
May 6, 2010 at 09:43 AM
Thanks Rizvisa for your answer. Some knowledge just fades away after not using it for a while. That's why I use this forum to keep my Excel muscles in shape. Thanks for helping me with my exercise :).

My graph is working very smoothly, thanks for asking!

Kind regards,
Trowa

Similar discussions

Message cannot be saved as draft (Yahoo attachments)
Cyberpope -
HelpiOS -

Hello, I have done all this; I've even moved the file to be sure there's not an error on the disk preventing a full clean upload.  My intention is to attach a small (2.6Mb) ePub file to send it to be read on my Kindle device. I put the correct "To" email; I put a small default subject & body message, then click the paperclip (I'm on Windows 10 desktop, using an up-to-date Chrome, select the file, click "attach" & it seems to operate normally, but then a big red "!" appears instead of a document icon; eventually it goes away, but only after I get a popup error from Yahoo: Message cannot be saved as draft. I click "send" & get error message in my inbox "your message could not be sent." Anyo...

1 response
Silk browser keeps popping up without me doing anything
IloveKats -
HelpiOS -

Whenever I get on my kindle, I don't even touch anything and silk broswer brings me to a really weird website with naked anime girls saying gross things when I did nothing! Please help me because its ANNOYING!!

3 responses
encryption message several time in chat
measking -
HelpiOS -

Hello, Why the end to end encryption message will appear several times in a chat at different dates with no other conversation? Does that mean the chat has been deleted and activated again, then deleted again at another date and reactivated again?

1 response