Hello,
The below macro currently works perfectly and moves a line of data based on the selection from a drop-down menu (data validation list).
I'd like to add a simple "are you sure you want to proceed" "yes" "no" style button message box when the user selects the item.
Private Sub...
Hi,
I would like to create a pop up window that displays the message," how many days would you like to accrue for _ out of _ days"?
The_ would be user input as to which excel then
1. Divides the values inputted
**for instance how many days would you like to accrue for 3 out of 7 days = .43...
Good morning all,
I'm having some difficulty with setting up a macro which will trigger if two conditions are met in a worksheet.
Require a message box to appear if the value in a particular cell (D4) in the D column shows the keyword “Supplier” and if the value in a different cell (H7) in...
Hi,
I have a spreadsheet with columns G-J setup with conditional formatting based on dates. the cell will change to yellow if the expiration is 60 days out, and will turn red if the expiration date is 30 days or less. I would like to setup a vba code that will give me a pop-up message upon...
HI,
I want a message box to automatically appear conditional on a checklist being completed. I am currently using
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("B3").Value = 0 Then
MsgBox "Checklist Completed- When XXXXX"
End If
End Sub
B3 contains a countif, i.e...
Hello -
I am trying to figure out how to create a message box that appears based on multiple criteria. I have tried doing research and still can not figure it out. I know minimal VBA, though I am confident it is possible.
I currently have a workbook that my project manager enters his crews...
Hi,
I have a sheet that I use for tracking invoices and have written VBA to highlight if an invoice with the same number has already been entered in column K as follows:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 11 Then
If...
I have a cell with conditional formatting to turn red when a certain condition is met. is there a VBA code that will display a message box stating duplicate based on a cell color? so what I need is when a cell turns red, a message box to appear showing duplicate.
here is the code I have but it...
Hi,
I have a workbook where they will be either a YES or NO Value in columns E, F or G. There will mostly be all NO values, but if there is a YES, i would like a message box to pop up and say "There is a negative fund, investment, or source!".
This is what i'm using now, but the message box...
I am trying to get a message box to fire automatically based on a cell value. Here is the setup:
I have a "configurator" tab (Sheet 2) that has an ActiveX drop down box with a list of names that corresponds to a table of names/job titles on a logic tab (Sheet 3). When you select your name on...
I am new to visual basic and need some help with some coding. I have a excel template that has an plan end date and actual end date (2 separate columns) if my actual end date is greater then my plan end date, I need a message box to explain they need to write a comment. If there is no comment...
Hello Everyone,
I currently have a worksheet that will populate days with the initials of the Staff that has been assigned a task that begins and ends in a certain time frame. I've used an IF function for this.
I now have another task I must do. My boss wants there to be an Error Message...
I have a workbook setup to not close if certain cell(s) are not filled out to prevent error (code below). However, it has become rather annoying if we need to open a sheet just for reference as we have to fill in all of the cells to before excel will close. Instead of preventing the worksheet to...
Hi There,
I am trying to get a pop up message box to display a list of names that may change each time you open the sheet.
I deal with new starters at work and want to have a popup box that finds the users who are starting in the next 2 weeks and haven't already been assigned a laptop. I have...
Hi,
I am trying to create a msgbox that has a list of items.
I have values in a column E. If the value in this column is greater than 1 I would like to take the information from columns B, C, D of the same row.
There might be no lines where the value is greater than 1 and there might be more...
Hi All,
I'm trying to automate a report in Excel 2010 and have got everything working expect for one small problem. Whenever I open the report, it runs the code (which is what I want but bear with me).
I would like to have the workbook automatically open (occurring from Time Scheduler) then...
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...
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...
I have a userform that has the user input a worksheet name, which I wave to the variable BorName. I have one IF statement to find out if the worksheet already exists. If it does exists then I want a messagebox thrown and want it to retry or cancel. The second IF statement just allows the sheet...
Hi
I have to put the results of a percent calculation (A3) in a message box in format '00.00 %'
I use the following code but I can't format the decimal places to only 2 digits
Worksheets("Sheet1").Range("A3") & Format(" %", "0.00")
Thanks in advance for your help.
Kind regards
Al
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.