pop up message

Good afternoon, I've created various sheets all of which have their own finalised percentage - as part of this, I was able to create a pop-up message that when the percentage exceeds 100% (or in the case '1' as I couldn't establish how to get it to recognise 100% on the VBA) a pop-up would be...

Hello Everyone! I ran into an issue with macros and I could use some guidance! I attach a sample excel file for ease of reference. I need to write a VBA code which needs to: 1) Check if a condition is met ("Other" or "Building") -> Column D If "Other", then multiply OMV (Column C) x 0.30% If...

Hi, I am having trouble generating a message when multiple conditions meet, the code I am using is below. The data is coming in from PI process book and are all declared correctly. If CV3033Run = "On" And FD3031Run = "STOP" And FDFD3032RUN = "STOP" And PC1SV < 400 And PC2WRB = "Off" And PC2ERB...

Sir, In Excel i want pop up message whenever the particular cell value has changed. The cell value is changed automatically while changing the value the pop up message appears in front of the screen.

Hello, I have the code below which I am using to send a spreadsheet by clicking a button. How would I go about having a popup message appear after clicking the button? What would the code look like for that? Thanks in advance. Sub SendWorkSheet() 'Update 20131209 Dim xFile As String Dim...

Hi guys I have created a workbook composed of many sheets that have charts..Each chart is populated thanks to dynamic ranges ("named range"). I download the data from Bloomberg, do some basic calculations on these time series and plug them into some charts, and update them every day with the...

Hello i want to display a pop up message when a particular textbox is empty in the userform before i click on the command button...is there any kind of vba code for that???

Hello ;) I am just wondering if it is possible that when I open an excel workbook (version 2010), it will remind me via pop up message that there is something due today? Example if date today is 14-08-14 -- removed inline image --- Based on the data above, I want excel to remind me that...

I want to create a pop-up message for two of the cells that contain a formula. Cell A10 counts dates entered in column A for the current calendar year. E10 totals the hours and minutes in column E. I was able to create the following code: Private Sub Worksheet_Calculate() If...

Hello, I'm trying to create a functional document to place on my company's internal site so new hires can have a centralized reference guide to figure out what we're talking about when we spout off acronyms and such. Nothing I'm doing seems to be working out the way I want so I'm in need of...

i would like to show a message when the workbook is saving as i have a big document and it can take up to 30 seconds to save. i would like the message to be displayed until the process is complete. does any one have any ideas? Would be a big help Thanks tom

Aloe all, here is my issue: When we print an invoicing worksheet, we adjust the page breaks depending on how many days/shifts we need to cover and we reuse the same workbook as a template for the next one. So, if someone was using one that covered 7 days and the next one only covered 1 and they...

I have this vb script which basically states if a value in column G is less than 0 then show a messaage box as below. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count <> 1 Then Exit Sub If Not Intersect(Target, Range("G3:G371")) Is Nothing Then If...

I want when excel file is opened. vba verify the date. if are on a certain date (eg June 30, 2012) will display a pop-up messages that have message: "The file needs to be updated. Click OK to renew or click Cancel to view the contents of the file" ... So in a pop-up messages have OK and Cancel...

Hello all, I don't have any experience with the macros programming however I have managed to create the following programme with the help found from older posts here: I have a spreadsheet with fields for writing down daily expenses so at one of the months (specific worksheet) I want a msgbox...

Hello, this query is more for my curiosity than need. I'm using 2007 and Win XP. What code do I use to answer yes to a popup generated by a macro? The popup occurs when I move sheets that have a vlookup formula into another workbook that has the same formula. The popup asks, "YES" or "NO", if I...

Can anyone tell me how to create a notification box pop-up that will open when I open the excel file. This will be a notification box that will list instructions on how to use the excel spreadsheet I am creating. Any help would be greatly appreciated!<?xml:namespace prefix = o ns =...