VBA Msgbox

Hey Everyone,

I'm trying to have a Message Box pop up under certain conditions. I've done some research and done some coding in VBA, but being a newbie, i'm having troubles. It's really trial and error for me.

Based on the attached sample file:

A message will appear with "text" when..... E4, E6, E8... etc = (text within a list on a seperate sheet) & Q4, Q6, Q8...etc = "Jeta1"

The list is actually called "Additive" under the tab/sheet "Lists"

Any help would be greatly appreciated. Thanks!

Maybe:

Please Login or Register  to view this content.

Whoa, thats intense! A little out of my league. I'm trying to make sense of it, but it looks like it's not working when I put it into VBA. ?

Hey Stnkynts,

An explanation would be awesome!

I'm using the exact same sample file to understand.

I copied the code from above and put it into the VBA. I then hit play button (Run Sub/ Userform). When I do this, I get the MsgBox. But when i fill in E4 & Q4, nothing happens.

Here is a screenshot of it working for me.

test123.gif

Here is a description of what the code is doing:

Please Login or Register  to view this content.

Originally Posted by Eaks77

I'm looking for when the cells are populated, the message will come up.

Ahh i see. You need a worksheet change event. Do you want it to run the check after you put data in column E or column Q? or Both?

Hmmm... I think it'll be best when both are populated

Ok try this. It is my understanding that you want to check the row that you are entering data in at that time and only that row. I wasn't sure what you wanted the message to be, but you should be able to see how to change it.

Please Login or Register  to view this content.

Hey Again,

I tried this code and it's not working. :s I've ensured that macros are enabled... But when entering data, no message appears. What am I doing wrong?

Thanks

Did you put it in the correct spot? Go to the visual basic editor, on the left side find the "Initial" sheet, double click it, paste the code in.

Hey,

Yup, its in the correct spot. :s not sure what i'm doing wrong. Could you send the file you have?

sample.xlsm

Instructions are on the first sheet.

Hey Again,

At first... it wasn't working. But I figured out why... the hint was all in your message . You said type in WEL into E4 and then "SELECT" jeta1.... however we rarely "SELECT" from the drop down. Most of the time we type in "Jeta1" and rarely select. I think this is where the problem is. If I select from the drop down, no problem! If i type it, it doesnt work. :s Is there a way to make both scenarios work? Thanks!

Ahhh didn't know it was that specific about capital letters. Unfortunately i'll need it to work for "Jeta1" "JetA1" "jeta1" and "jetA1" Is there no way to set it up so that it doesnt matter what is capitlized? Thanks again for all your help!

Please Login or Register  to view this content.

This is perfect!!!! Thank you very much for you help and patience Stnkynts! It's been an education!