pop-up

Experts: I would like some assistance with tweaking VBA output in a pop-up text box (upon opening Excel)... please see VBA code below: As of now, the pop-up (data) is driven by values in the actual spreadsheet (I didn't know how to attach the sample file). Right now, the labels (A1:A3) are...

I am brand new to macros so please feel free to dumb this down as much as you want. I am beginning a new position and am revamping the timesheet process, which is done with Excel. There is an issue with incorrect time reporting, and I would like to create either a pop-up or yes/no button that...

I had several pop-ups with the following message "Unable to open http:\\<website here=""> The internet site reports that the item you requested could not be found. (HTTP/1.0 404)" I cleaned up the file, which had broken links from early 2000s, by cleaning-up the following: - Formulas from the...

Hello. I need a help to prevent other people saving on the master file. The approach is the following: 1) Clicking on the button "Save", I need the pop-up "You're saving with the same name" and stop the operation; 2) Clicking on the button "Save as" without changing the name, then pop-up...

Hi there I would like to generate a pop-up message "Warning! Please check value!" if any of the following cells A4, D5, G7 contain any character. Thank you in advance!

Hi all, I've been going through forum posts quite a bit today for some code to show a pop-up message when specific text in is any cell of one column. Probably really simple but I've gone around in circles. What I's like is for a pop-up message to display when the a formula gives me specific...

Hello everyone ! basically need some help figuring out why this is not working like it should. will try and give a brief overview first. want to check if a company renewal date is due and alert accordingly on opening of workbook. have put down code that i'm using as under : Sub...

Well, Im not sure if I should be using On Close, that's the question. I want to conditional format certain fields and have message pop-up if the user tries to close the form and there are fields they should have completed. 1) do I use the On Close Event? 2) on the Pop-up Message, I want the...

Dear members! I would like to ask for some help regarding the following problem: In my workbook I have two sheets. Sheet 1 contains two columns with data. Sheet 2 contains two columns with a list of words/phrases. I would like to achieve the following: if the data in Sheet 1 differs from the...

I have an Excel 2010 Spreadsheet. In Column A I have a list of names and in column B I have a list of dates. I would like to know if it is possible to create a pop-up box that will inform me if any of the names in Column A have worked on a Saturday, Sunday or any Bank Holidays. Column A is...

Hi all, I need to create a pop up message for a whole column/ or A1 : A 60. if the value in B1 is greater than or equal to 100 I am new to VBA in excel

I have gone through the coding and now have the option to select a cell, right click, select "Insert Date" and then select a date from the pop-up calendar that...pops up.... The date is then input into that cell. I need to know now how to format that specific cell to pop up that calendar...

I have a macro button that automatically runs three reports (excel spreadsheets) from my company's intraweb database application. The only issue with this is the hyperlink warning message that automatically pops up. It basically warns that some files from the internet may be harmful and make...

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...

Posting for a co-worker. Thanks for the help. ----- I want there to be a pop up window that comes up when the formula under the GP line is under 35% that tells you to write an explanation on the LOW GP line. So far, I’m able to get the color code system under GP working for me, and I could...

Hi All, I am currently producing a work number tracking spreadsheet for the people I work with and wanted to know if there was a way to generate a pop up window that created fields to enter the data for the job being inputted. I currently have it just a simple macro (below) that enters a new...

Hi, I'm trying to program a relatively simple pop-up box in Excel, but I am not too familiar with <ACRONYM title="visual basic for applications">vba</ACRONYM> code. The situation is that I have a worksheet in an excel workbook linked to a .csv file that updates daily with inventory information...

Hi, I'm wondering if there's a way to have a pop-up message if certain options are selected from a drop-down menu. I'm using Excel 2010 to create a form for information regarding medications. I've used Data Validation to create drop-down menus of all the possible medications that the form...

ActiveWindow.Close The above code in my macro. When I use this command, it has a popup that asks me if I want to save my changes. I want it to not give me the popup and just close the file. I do not want to save my changes. is there a command I can use that will just close the active...

Hi, I wonder if you may be able to help me - I would like a pop up text box (similar to data > data validation > input message) to appear when you click on a cell, but then I want the user to be able to edit it by clicking on the box (rather than going into data validation again...) So not...