pop up box

  1. B

    VBA to pop up a box and run the code accordingly

    Hi, Can someone help me with the below requirement. I have a code that is running fine but I want to place a message box in between to give a break to the code to do some manual updates. I am looking for code that pops up with a message asking to do manual updates in workbook and with option...
  2. S

    Need help to change figure from positive to negative

    Hello everyone, I am working on a VBA code which changes positive figures to negative figures and vice versa. The code works fine if i select more than 1 cells but if i select only one cell to change the figure from positive to negative or negative to positive then all other numbers get changed...
  3. N

    Pop up alert when due date is reached / link cells of different sheets to one "main" sheet within same workbook

    Hi! This is my first time posting a thread so please be nice to me .. :cry: I have a workbook with 11 sheets - sheets 1-10 have Due Dates (E7 - E50 = reserved for the due dates even though some sheets only have 3 rows filled with dates). Sheet 11 is supposed to be like a main/front page...
  4. J

    Copy specific worksheets to new workbook (as values). Save as

    Hello, I am attempting to do the following: Copy all worksheets whose name ends in "-PP" into a new workbook (formats, values - NO formulas) Open a pop-up box in the new workbook that asks the user to enter the version number Open the save as window and save the file to the user's desktop as...
  5. L

    pop up menu with options to select

    Dear All, I am trying to create a macro to be with assigned to a button with my little knowledge of VBA, maybe you can give me a hand. What I want to do with the macro once I click the button is: - open a pop up menu containing a list of options - user select one or more options - specify a...
  6. N

    Excel VBA: DropDown Select Macro

    Hi All, I have an excel, where a drop down is created using data validation icon in Excel. there are 8 entries. There are 8 other hidden sheets in the excel whose name match that of the entries in the drop down list. I need a piece of code, where when the selection is made in the drop down...
  7. S

    VBA To Populate Pop Up Message In One Sheet, Based Off Cell Value In A Separate

    Hello! I'm trying to have a pop-up message occur on a tab ("Analytical Approach") that gives the user a warning, only if the value "3" is present between cells B4:B12 on a separate tab ("Control"). The cells in in the Control tab are populated based off of a Form Control button on Analytical...
  8. P

    VBA Pop-up Box

    Hello! I'm trying to create a pop-up window using VBA. I've been using a post by Trevor G and Lisa1, and I belive I've gotten quite ahead on this, but I can't conclude my window, as this is a bit more complex than the one on the mentioned post. Here's what I have so far: Private Sub...
  9. E

    Make slicer selection via Userform upon worksheet opening.

    I have a dashboard with several sheets displaying charts in various levels of drill down. While the sheets at the global level are very clear and easy to read, the sheets at the manager level are extremely busy until a Manager is selected in the slicer. Is there a way to have a userform pop up...
  10. C

    Popup if value in range is less than 5%

    I have a range of cells in row 39, with calculated percentages. If a change is made that makes any cell in the range fall below 5%, I would like a popup stating "Exceeded 5% Availability". This is the VBA code I'm using so far with no result. Private Sub Worksheet_Calculate() If...
  11. L

    Pop-Up Message for only when a cell's value changes and not when other cells change

    I want to create a pop-up message for two of the cells that contain a formula. Cell A10 counts dates entered in column A for the current calendar year. E10 totals the hours and minutes in column E. I was able to create the following code: Private Sub Worksheet_Calculate() If...
  12. W

    Create a Pop Up Text Box Able to Store Info Entered

    Hi, I don't know if this is possible, but I need to create a pop up editable text box. I want to have a button that says 'Enter Comment' and when clicked, a text box pops up where someone can enter their comments. After pressing 'OK' on the text box, I would then like for this information to be...
  13. K

    Excel 2007 Create a Pop Up Alert if limit is exceeded

    Hi! I'm creating a spreadsheet to calculate the total travel time between various destinations - I have already set up conditional formatting so if the total travel time exceeds 2 hours for example - the cell will turn red. What I want to do now is create an alert that will appear when the 2...
  14. N

    I need a pop up box in excel is needed

    I need a pop up box in excel as follow Cell E3 has a text based on formula Cell C3 has a text based on formula Cell C4 has a text based on formula What I need When data inputted in cell B3 or B4 a pop up screen will appear with the value in of the three cells in three lines E3 C3 C4
  15. B

    VBA for Popup to select a file

    Hi I am working on a project where i need to create a macro and give it to a user. The task is to create a popup window so that the user can select a file from a folder in their PC. Thank you
  16. G

    Macro Needed to Pop-Up Message Box Selection

    How do I create a macro in excel that when activated, asks the user to select an employee name from a pre-programmed list? I'm thinking it would be something to the effect of Radio buttons listing approximately 5 employees plus a 6th employee would be "Other: User types in name." () Bob ()...
  17. P

    Need pop up box to allow user to map to field on a different tab

    Yes, horrible title I know :)- here is my question: I currently have a spreadsheet set up where I have users use the simple = to map back to a field location on a separate tab. What I would like when they either click in the cell where the data will be mapped to is for a pop up box to show up...
  18. D

    Question Box

    Hi guys, Need some help. I need some VBA to create a pop up question box that will ask you a question with a part to input your answer and this then feeds in to a specific cell on the sheet (which will be referenced by the name manager) Example would be: What is your name? You reply...
  19. K

    Pop Up Disclaimer

    Hello all, I was wondering if someone could dumb down some Excel setup info. I need to set up a pop-up disclaimer where a user of a spreadsheet would have to accept the terms in order to view the sheet. Is this possible?? If so would somebody please inform me on how to do it? Thanks! :cool:
  20. W

    Pop up

    I have a spreadsheet with data in a1-b10 and I would like a popup window that i could move to another screen that someone else is looking at. When i update the data in a1-b10 i would like the changes to be seen in the popup. Is this possible?
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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