message box

I have a macro that runs and throughout the macro the user is presented with several vbYesNo message boxes. However, when they make their choice on each one, each message box stays displayed on this screen. Once they pick Yes or No (or Cancel), I would like the message box to go away and the...

What I Want: If no rows are named (the input cannot be found), a message box appears saying "No Results Found." Added bonus if you can help me figure out how to do this: If rows are named (the input is found), a message box appears saying "The following rows were named:" and then the newly...

Hi guys, I'm having trouble with some VBA I've put together. It basically just hides and Unhides worksheets which all works perfectly. The problem I'm having is with the message box. "el" is always returning the next sheet in my mylist not the not the actual sheet which is not in my...

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

I am new to VBA and I am using a code that will have a message box pop up if a value is less than another value. The box will appear if a check box is clicked, but if the value is less than the other specified value, I want the check box to uncheck itself. I know this is the reason why the...

I am pretty sure this is very easy and i found a code that did this sorta thing on this website. BUT...what it did was it focuses only on one cell, while i need it to check the whole column or at least a range of cells within a column. lets say column B and if a cell value in column B falls...

Hi, thanks for all help in advance! I need help writing a script in VBA which is conditional on an active cell being either blank or with characters i.e if specific cell (A1) is blank then Message Box appears otherwise do nothing Thanks!

I need a macro that will check to see if Sheet 3 has been updated or new data entered. If updated, show a message box asking “Would you like to reorganize sheet now?” Yes or No. If Yes, run/call macro “Reorganize()”. If “No” Cancel. Thanks so much, -Tmoske

Hi, I need help and I hope someone is clever enough to un-jumble what I've written below and then help me sort out what I need :) I've created a time sheet for my work. Within the time sheet I have created an IF formula to work out how many hours the person is supposed to work each day so that...

Im trying to create a time sheet for work. I have created it so that one column auto populates with each persons expected hours, and a hidden column next to it shows the difference in the hours that they were supposed to work and what they actually worked. I would like a pop up message to warn...

Hello. I am new to the site but have already found a TON of helpful information! I would like some assistance with a 2007 Excel spreadsheet. My company currently shares ONE spreadsheet to generate new project numbers (Shown below). My issue is once a new number is assigned, it is supposed to...

Hi I am VERY new to VBA and am starting to get confused! I have a spreadsheet that monitors employees rest periods between shifts across a number of weeks I've started writing a very basic piece of code so if the employee has less than 12 hours rest, a message box will appear with a warning...

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

Hi I have a message box that will come up once my Macro is complete. It's just there to let the user know that they can take the next step. Just for aesthetic purposes, I want the formatting to be better. Its currently all crammed in, I would like it to be on separate lines after each full...

Hi, I'm a newbie to macro, and am stuck...help! The worksheet needs to automatically pops up a warning message whenever range of cells K12 to K27 equals to 815500. I got it to partially work with the code: ______________________________________ Private Sub Worksheet_Change(ByVal Target As...

Helllo again Forum: I have a macro that works, but when I added in a MSG box, I discovered something very strange. Right now the Macro updates pieces of infromation (those are the only thing population the I8 range in the Adjustments tab.) By inserting the message box, I see that the Macro...

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

Hi, Have just joined the forum here as it seems very helpful and looks like there are many experienced Excel users willing to help find solutions to 'problems'..... I am trying to develop a system to allow me select different parts from multiple sheets and then add them into a bill of material...

Hello, guys! I work in a company that provides electrical services. One of the jobs that was given to me was to control how much of cable were already pulled into the cable trays. Since one of the clients we have had purchased a specific meterage of cable to be pulled, I need to know when the...

I have a code that ends with a message box. I would like to have that message box randomly choose a message each time the code is run instead of saying the same thing. For example, when the code is run, the VBA will choose from message A,B, or C and that code (which will just be a message box)...