pop

Hi All, If I'm using a code to produce a dialog box to save the file, I've noticed that the dialog box does not pop in front of the excel document but sometimes behind it. How do I express in code for the dialog box to pop up in front of the working excel document? Please let me know, if...

Hi,would the following be possible with VBA...I would like a warning message to pop up when a particular selection is made from a drop down list in a worksheet, or in a specific range if it must. However, I want the message to pop up only the first time that selection is made, so suppressed...

Dear team, How to add picture into cell & resize automatically to cell size & should be hide & pop up when mouse over again hide when cursor removed from cell

Hello, I need assistance with a little bit of VBA code. The code needs to: Identify all the blank cells in Column D, It is the last column. Display a pop up dialog / Userform A response is entered by the user in the dialog. Whatever is entered into that dialog will then fill ALL of the blank...

So basically, I click on a button, some things pop up, and it names my sheets for me. However, I'm having a bit of a hard time trying to get it check to see if there's already a duplicate sheet name. Right now, it works perfectly, until I create two worksheets with the same name. Would anyone...

Hi all I’m looking for a vba-macro that will pop up a warning after 5 min inactivity and then save & close if still idle after 5 more min. Ideally the clock would restart after the pop up is close. Thanks in advance/ Office 2016 if it helps Cooky857

Hi all I’m looking for a vba-macro that will pop up a warning after 5 min inactivity and then save & close if still idle after 5 more min. Ideally the clock would restart after the pop up is close. Thanks in advance/ Office 2016 if it helps Cooky857

Hi, May someone help me with a VBA code for excel to pop up a word every 5 minutes in a range to remind me new vocabulary. For example i have a list of words as follows in excel: <tbody> Permeate Pummel evict behemoth rejuvenate </tbody> I would like to have Excel to pop up...

Hey all, I would like some help on creating a stopwatch that works every time a key is pressed and stops every time the same key is released. A pop up that should let the user know for how long the key was pressed for. This should work for any key. eg format for the pop up window The key...

Hi, I was hoping that someone could give me the code for thefollowing. I wanted a pop up box for users to fill in 4 columns ofinformation. Col A would be “Date” B “Site” C “Tonnage” D “Reason” isthere a way that it will auto fill the newt row? So row 1 has the header titleso the info would need...

Hello, I have a pretty big file to run and attempting to have a "please wait" pop up windows whenever the sheet recalculate. However, the code I pasted below does not seem to work. When I see "Calculating ..4 processors" in the bottom right of the page, the pop up window and worst the code is...

Hello, I have created a form in excel and have cells E3, E7 and E19 that are drop downs that need to require information to be selected. E3 has "Select Name", E7 has "Select Reason" and E19 has "Select Yes/No". Can I have a message box that would pop up if any of those boxes have those key...

hello awesome people i have an excel worksheet named Transit time who has integers as it counts days. i want to have a pop up window in excel with a message like " you still have 7 days" or anything else if the transit time is less than 7 days per example , but i also want it to do two things ...

I have a UserForm that pops up when the Sheet is opened for the first time. The UserForm only contains instructions and an "OK" button that makes the UserForm unload. The only problem now is that the UserForm will be popping up every time the sheet is opened. Is there a way for the User Form to...

Hi There I have a few pop-up calendars in my workbook. The calendars pop up fine if the cells are not merged. However on a merged cell (for example A1 and B1), the calendar does not pup up. I'm OK with that but I was just wondering if there is a way to make the calendar pop up on a merged...

Hi There I don't know how to download or install programs from the internet. My Excel 16 does not have the following: Microsoft Date and Time control Microsoft Monthly View Control. I need at least one of these controls to do a pop up calendar and it is too complicated for me to download...

How do I create a Data Validation formula for Column C? If a person tries to enter a number in Column C when an "X" is in a cell in Column B, would like a pop up box to open that says "Miles Not Allowed". I would prefer not having to create a VBA formula. Also, would I need two different...

Hi All, I want to disable all type of any error like some OLE/DDE message or any debug error pop up window in excel. Can anybody tell me , if this possible if yes, than What is the code for same. Thanks in advance for your valuable suggestion. Regards, Rajender

Hi all, Can you write Macros in Access just like Excel? Is there a way to create a pop-up message when one of my columns contains "Immediate Action"? I would like the pop up to List correlating data in other columns as well. For instance, I imagine the message containing: Site: (Name)...

Hi all, Is there a way to create a pop-up message when one of my columns contains "Immediate Action"? I would like the pop up to List correlating data in other columns as well. For instance, I imagine the message containing: Site: (Name) Contact: (Name) Status: (Should say Immediate action...