pop-up

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

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

Hi I'm tying to send a Excel generated mail with attachment from Outlook, but get this security message: A program is trying to automatically send e-mail on your behalf. Do you want to allow this? If this is unexpected, it may be a virus and you should choose "No". Excerpts from the code I'm...

Whenever I try to trace the dependents on a cell that has no dependents, I get a pop-up that says "The Trace Dependents command found no formulas that refer to the active cell". Previous versions of Excel didn't have this popup. How can I suppress it? Thanks

Is there a way to create Pop-Up Alerts/DialogBox - based on a cell value - (kind of conditional formatting) ... ?

Hi all, Back again i'm afraid with more help needed. I've got a Macro that, when activated, allows the user to cancel a demand and highlight that row red when completed, here's the code: Sub Cancel_DMD() Dim datatoFind, sRemark As Variant Dim sheetCount As Integer Dim counter As Integer Dim...

I'd like to display a pop-up message on startup for an Excel file. The message would simply give a brief 3-step on how to use the file (calculations, etc.) I've created pop-ups to validate cells before, but not this. Anyone have a way for me to do this? Thanks.

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

I have seen this trick before but am unsure how to do it. I have data in a table in a worksheet and have a chart created in the same worksheet. I would like to be able to click on a cell (or some point) in that worksheet and have the chart pop up over top of the data in the same worksheet. Then...