pop-up

  1. L

    Code to create a pop-up window with a text field - entries should be logged in a sheet

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

    Home inventory cell pop-up

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

    Parts lists pop-up

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

    Popup when file name is "X" but when it is changed dont create popup

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

    How to create a pop-up reminder when a certain cell is chosen but dependent on a value of another cell?

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

    Remove Read Only Pop-Up Message when Opening a Worksheet

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

    Unprotected sheet warning

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

    VBA for Pop Up Message with Condition

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

    VBA - pop-up table to search files

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

    Pop-up message when opening file when date criteria is met

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

    Pop-up UserForm in an exclusive computer.

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

    Pop-up calendar not poping up on merged cells

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

    VBA code for message box (pop-up)

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

    Created a Pop-up Macro with "Add Part" Button, Pop-up Fields no blank for additional parts! Help

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

    Help creating a pop-up message when data is entered into a cell

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

    Personal Macro disable notification

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

    Message Box Pop-Up - Quarter Query

    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?
  18. B

    Getting a pop-up as Query1.MyDate

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

    Enable macros with pop-up bar/dialog box rather than "File" menu button

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

    Formatting a Start-up Pop-up Box

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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top