pop up

Hello. I am new to the site but have already found a TON of helpful information! I would like some assistance with a 2007 Excel spreadsheet. My company currently shares ONE spreadsheet to generate new project numbers (Shown below). My issue is once a new number is assigned, it is supposed to...

Hi all, I am really stuck here. I am trying to automate checking of card balance at this link...

Hi! I'm creating a spreadsheet to calculate the total travel time between various destinations - I have already set up conditional formatting so if the total travel time exceeds 2 hours for example - the cell will turn red. What I want to do now is create an alert that will appear when the 2...

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 Everyone, I was wondering if there is a way in excel-vba to do this. In sheet A, I have 10 tables. Each table is assigned a table name and has two columns (a list of fields in column 1 and the corresponding data types in column 2). I have added a hyperlink to the cell which contains the...

Hello Forum, Anyone know why I am getting this pop up and how to get rid of it.

I'm trying to create a popup messgage box based on a cell value in a worksheet. I have multiple worksheets in my workbook. In my 1st worksheet "Bridger" I'd like a pop up box to appear when/if AE3<=AE4. The message will say "Time to order tickets". The remaining worksheets will have...

Hello All, In Excel VBA, I am trying to create a single macro that will A) search for a string (let's say "Bay") within an entire worksheet B) return all results of the search containing the string in a list ("Bay st", "Bay Av", "Bayview", etc.) C) allow the user to select one entry...

Hi there VBA Gurus, I have a few icons on one of my worksheets, is it possible to have text pop up when then mouse icon is over the image? how would I go about doing this with VBA?

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

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

Hiya - I need help with some code. I've created a form and need instructions in a pop up window to go with it. What I would like to do...when you click the form to open - the first thing you see is a pop up window that says - Instructions...select items from drop down list, click outside drop...

I am trying to create a stock trading template in Excel. The template/worksheet will be minimized/running in the background while other applications run in the foreground. When certain cells in the template/sheet populate certain values (based on formulas or by referencing other cells) - can...

how do u add error message, so that if you do not put the correct type of value in a input box and a error message should come for you to re do it again error message should not take letters, signs etc onli numbers and if number 0 is entered it should stopped