Hi,
I want to have a window popping up if the cell content of "F6" says "important" (F6 contains an if statement)
I want the macro message box to pop up ONCE only for users to see and be informed
the message content should be "based you the ranking, please answer cell D"
ideally the macro applies to all rows in colum F - not only F6
any ideas
thanks a lot!!!!
Just trying to clarify,
You'd like to loop through all cells from F6 to the last row in F and display a messagebox if the cell contains important?
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
Solus,
thanks for getting back to me... yes indeed - each row represents an independet process step and is populated at a separate time, therefore everytime when F states "important" the pop up window should appear for the user to click OK and then proceed
Try:
Please Login or Register to view this content.
In the event that they type important in differently you could try:
Please Login or Register to view this content.
Solus...
thanks but unfortunately no window pops up...
maybe let me try to be more specific...
F6 (until F100 for now) contains a formula which says that if the selection in a previous cell (D) is x then show imporatnt in cell F.
Now if this is the case, the user will be required to fill out more cells and therefore I would like to have the message window pop up...
Is there anything else that I must consider... spelling? or the range that we used...
sorry for not being more helpful
tanks
laura
Could you redact any private information from your spreadsheet and attach an example? It worked fine on the very limited test sheet I set up.
Hi, Solus,
really look in Column A when the formulas are in Column F?
Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Good catch. I mindlessly typed that in assuming all columns would be filled if D & F were
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks