pop

I'm looking for the vba to evaluate every cell from BI49 to the last row and if there's an N/A then pop up an error message and exit program. I had a similar request yesterday, but I can't get the syntax right.

Hi Everyone, so I have a sheet called "Totals" I need a macro that when run can look along row 8 find the name in cell B5 look at the value in the cell above it and if its a zero pop up a message box saying " No DATA" please help if you can Thanks Tony

Good morning. I have to prevent manual errors in a data entry operation: more precisely, if the user types a space " " in a cell in the range F11:F13, a pop up has to specify in which cell, to make easier the consequent correction. This is my attempt: the error is located in the highlighted...

Hello everybody. In opening a file from an intranet, the following pop up is displayed: The file you are trying to open file.xls is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you...

when i was opening file it is pop up on my spread sheet(Autosaved) recovery file Can we do it like this close it automatically,it should not pop up on my screen. Any macro or tips for it?

Hello Everyone, I'm trying to import a file based on its "name" &/or "title" to a specific sheet. Where, if the file is not present the sub will pop an error msgbox indicating such. Any suggestions?? Thanks, Pinaceous

Is there a way to have more than one Data Validation in one cell. I have a drop down menu on the cell with about 20-30 names. Now i want a error to pop up if they do not select who they are.

I'm trying to writre a macro in vba that can read the inner text from internet explorer pop up window that appears a few seconds later I put my password and user name in the web page. Can someone help me with this!???? Thanks in advance. Alex

Hi Everyone, i'm new to this forum and would really appreciate some help. I have developed a spreadsheet that tracks crypto currency prices and volumes via a generated web query with API's and refreshes every 2 - 3 minutes. I then have a VBA code that detects a change in a cell value (after...

I am making a spreadsheet for work i need to make a code that will allow a pop up for several cells for an expiring date would be what ever today is i have been unable to locate a code can anyone help the cell in which i would need for this to work in are most of the sheet it starts at B to K...

Hi. I'm new to vba and need some assistance, with thanks. I've run all my macros and they are seem fine, except that when I close the file and the save pop up message pops up and I click on save, in fact it does't save my work! how to override this? I've googled this a lot and only found...

Hi All, How do you run a timed pop up to pop up on certain opened tabs of your workbook? For example, if I'm running YourSub1 to execute at ie. 12:00pm I want it exclusive for sheet 1 and no other tabs. Thank you all in advance! R/ Pinaceous

I need help on a Macro where the user inputs data into a pop up box. That data is then copied into another sheet.

Hello, So right now I have some coding set up to display a pop up box if any of a certain 4 cells contain specific "yes" or "no" answers. That coding is here: Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False If Range("B5").Value = "No" Or Range("B6").Value...

i have a document that is shared by 5 different people in our office, and often people forget to leave it open. Im struggling to write a macro that would make a pop up appear every 15 minutes to remind people to close the document if they are finished editing it. any suggestions?

the table contains a string that is too long for excel to display. if you edit the long value some data might be lost Does anyone know what this is? I dont know what happened, I have been building a spreadsheet for a few weeks now and everything was running smooth. Randomly during this versions...

I would like to include a pop up comment type of box with either gif or swf animation playing in the pop up box. I know that you can add a comment to a cell and change it's format to show a picture as a pop us comment. But gif animations don't play when implemented that way. Hope you guys can...

Hi, I prepared a tool to generate total solution pricing with multiple products. Tool has input sheet where user can make product selection and in same Input sheet, there is a "cell AB2" which shows Total Solution Price based on selected products. So, Total Solution Price (cell AB2 of Input...

Hello everyone, My first time posting on this forum so please excuse any mistakes I make. I have created a macro button to move from one sheet to another in an excel document but I want also want the button to check to see if multiple ranges of cells have values, if they don't then pop up a...