pop up box

Hi All, I've been searching through this forum and others for a few days, and with my still limited VBA knowledge, I've been unable to find a VBA script that can assist me in achieving my goal - most of the solutions are for preset future expiry dates. To the question - I have a master...

I am a complete VBA novice and searched this forum to solve my issue but I still can't figure it out. I have a workbook with 3 worksheets and need a pop-up when opening the workbook. All the info for the pop-up will be derived from the 1st sheet which is named "OpenCases" Here is a screenshot...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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