popup

This is probably a very far out there request but here goes....... Is there a formula which will magnify (preferably in a pop up box) a particular column heading when I am on a particular cell within that column as 1 step further I wish to have the functionality to turn it on and off as a...

Hi. I posted this on another page but wasnt sure if anyone would see it. Is it possible to have an item in a cell, say "Apples" and then be able to either click on that cell which leads to further information either on a different worksheet or as a pop up box. So say I wanted to know abit more...

Hello, I apologize if this has been asked anywhere, but I could not find an answer to it. I have to say that I am not familiar with VBA right away, so please do not expect much from me. I have coded in C, C++, JAVA etc., but VBA I am not familiar with. Anyway, here is what I am trying to find...

I guys long time user 1st time poster. I am hoping someone will be able to give me a hand or at least point me in the right direction. we are looking at a number of ways to curb paper use (currently 25,000 a week). I found that often people printed multiple copies due to the settings not...

I have a macro enabled document (.xlsm) that I want to save as a standard macro-free document (.xlsx). I am able to do it but it creates a popup asking me if I want to do it and lose the macros. Is there a way to avoid the popup and have it just save the document without the macros...

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, Hope you can help with this infuriating issue. I have a ASP web page one section of which allows me to remove certain data from the page by click a "Close" link. The link is a straight forward HTML affair, and I can automate the clicking of it, however, it comes up with a confirmation box...

Hi All, I have an Excel workbook I use at what is basically a receiving desk. It has two password protected sheets labeled Received and Expedited. Each sheet has 12 columns. The cells of the first row of each sheet are locked and are used as column headers. The cells in each row below are...

This may sound stupid as you can already do this via the toolbars, however. Can anyone please provide a script that will call the macro popup list (list of all macros and then you can select which to run) as I want to activate it via a form that is in my workbook as I use different versions...

I am running Excel 2007. I know I have seen the answer to my question on this forum in the past, but I cannot find it with a search. When I delete a worksheet during the execution of code a popup message box pops up asking me if I want to delete the sheet. How can I stop the popup message box...

Hello, I'm blanking on the best way to do cleanly accomplish this. Basically I want a popup to ask the user which file to use. In the dropdown from the popup I would want it to list all open excel workbooks and then the rest of my code will establish that selected workbook as a name and then...

Hello all,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> BASIC HISTORY OF WHAT I'M DOING<o:p></o:p> I have a popup calendar that appears when a user selects/activates a specific cell (e.g. B6) by single mouse click or by navigating to the cell...

Hi - Can someone provide the code so I can create a "popup panel" of macro buttons when a single macro button is activated? I have 4 or 5 macro button options but I don't want buttons all over the screen so I was hoping to have a panel of macro button pop up when requested. Thanks - jtk

Hi I want to be have a msg box pop up when the sum of a set of cells (range1) is more than the sum of another set of cells (range2). If range 1 > range 2 is true, then it needs to check a cell (A12) is not blank. If the cell is not blank, do nothing, if the cell is blank then pop up a message...

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

Hi everyone, I've set up two list boxes in an "add>" and "Remve<remov><remove></remove></remov>"<remove></remove> configuration with the option of multiples selections. After the user has populated Listbox2 with all or some of the items from listbox1 and upon them pressing a "proceed" button...

Hello all, I have a table (tblDatabase_Rocks) where details of field-collected samples are entered into via a form (frmRocks). Each record has a unique Primary Key field (SiteNumber). These are entered into the txtSiteNumber control on the frmRocks. Occasionally, an address will need to be...

Hi all, Thanks for all the great people who make this resource the "end of the rainbow" for those of us still learning all the wonderful abilities of Excel :) My Task: I have a VB script that needs to trawl through multiple webpages downloading a file on each page. The file download is...

Hi I have some information in tables on a spreadsheet that I would like to appear in a little grey popup box. E.G. When the person clicks on a link in a userform. I would like another userform or something to pop up with the information in say 'Sheet2'!A1:C5. arranged as a neat little table...