pop-up

Hi Everyone, Semi new to VBA code but always hopeful to learn something new. At my previous company, we had a time management software that pop-up a window asking "What are you doing now?" but at the new place the IT security issues are so great (can't get assess to Task Manager) that they...

Hi there, i made a small parts list. In column A 1-99 each cell will have an item. Ex. A1 saw, A2 hammer, A3 screwdriver. When i click on an item such as A1, I would like a form with labels and text boxes to pop-up. i know i can make a form that matches my headers but i would like certain things...

Hi there, i made a small parts list. In column A 1-99 each cell will have an item. Ex. A1 saw, A2 hammer, A3 screwdriver. When i click on an item such as A1, I would like a form with labels and text boxes to pop-up. i know i can make a form that matches my headers but i would like certain...

Currently I am using the following in a spreadsheet we use for internal reviews. Private Sub Workbook_Open() MsgBox "Click OK, then please save with your file name before entering information onto the form", vbOKOnly + vbExclamation, "ATTENTION!!!" End Sub Is there some language I can use to...

Hi, I would like to ask: How do you create a pop-up reminder when a certain cell is chosen but dependent on a value of another cell? To be specific, we have the type of service cell J2. "Transportation" and "Guiding" is part of a drop-down menu and every time they are chosen, there is a...

I had password protection added to a workbook so other viewers could not make changes. I removed the protection and re-saved some of the worksheets. Although a password isn't required to open any of the re-saved worksheets, a pop-up appears on opening advising the user that selecting Yes will...

Hi everyone, I have a sheet which has to be partially protected (with some cells always editable) and, sometimes, I unprotect it to change a formula. It is very important for me not to forget that I must protect the sheet again. I would like to have some kind of Pop-Up that warn me when I...

Hi There! I need a macro to generate a pop-up message when a condition is met. Thanks!

Hi, I have many pdf (now about 4k+ and will be increasing from time to time) which saved in a share folder (F:\). My engineers will always come to me to check if I have the Part pdf in my pdf list. Can I have a pop-up table for the engineers to input the part # they need for the pdf and if YES...

How do I create a pop-up that appears when a file is opened if today's date is beyond a set date of the year? In other words, when today's date is after December 15, 2018, the pop-up message should appear when opening said file.

Hi everyone, I have this Workbook with several UserForms. The Workbooks is shared between 2 or 3 Computers simultaneously. It is shared using the old way not the cloud. One of the UserForms will work just like a Pop-up message in one especific computer. But, since it is just one workbook, I...

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, I have few cells where "Yes" or "No" to be selected from drop down. When the selection is "Yes" I need message box to pop-up. Likewise there are around 7 cells with 7 different message to pop-up in message box. E.g., A1 = Yes "Msg 1" A2 = Yes "Msg 2" Likewise for 7 cells. If "NO" no...

I'm using this macro to populate my parts database thru a pop-up dialog box along with a "Add Part" button that initiates the Pop-up Dialog box using the module below. It works great for the first part! But when I push the "Add Part" button for the next part, the fields are still populated...

I use an Excel spread sheet to sort and analyze info from Survey Monkey. I download the data from survey monkey and copy and paste it into my spread sheet to convert most of the data into a Word document. I used to get a pop up message when I input the data if a certain cell said "yes", but...

Hi there, I have a personal macros in Excel which I use and I always get the below message when trying to open other workbooks if I have one open already. Is there a way to not have the notification pop-up? Thank you

I created a query that displays data based off of Quarter 1 using DatePart("q",[Report Date])=1 in the Criteria section. However, what would I need to do if I wanted a message box to pop-up when I ran the query or report asking which quarter I would like to display?

Hi, I am using below query to get details from database. SELECT Designation, MyDate, Count(Designation) AS MyCount FROM Combine WHERE Designation = 'Senior Dummy Manager' GROUP BY Designation, MyDate ORDER BY Count(MyDate); However, whenever I click on query, I get a pop-up as...

It appears that MS Excel opens macro-enabled workbooks in one of three ways: (1) A pop-up bar that includes an "Enable macros" button; (2) A pop-up dialog box that includes an "Enable macros" button; or (3) No pop-up at all with a hidden "Enable Content" button maddeningly hidden within the...

Hi All - I have a pop-up box that gives some information to the user when they open the spreadsheet. The information is fairly long and the manager who wants this spreadsheet to have this pop-up box with all this information is now concerned about the readability. Is there a way to format...