i have a column(G) in a spreadsheet active sheet will do. i would like a message box to pop up if nothing is populated in the cell from range g1 - onwards...range does change otherwise keep processing code
View 2 RepliesI have attached one excel sheet. I have programmed this in such a way that it always asks the name of the person who opens this excel. Then the name & date with time autometically noted. I have used password "007" in this excel sheet. The code is below:-
View 14 Replies View RelatedWhen the whole row in excelsheet is full for particular date that means all the values of columns (Legal Charge,GA and DNM) have been entered for particular date then display an error message if the another user tries to enter the values for the same date .
It means the user can enter the values for same date only if values of Legal Charge,GA and DNM are empty,otherwise an error message should pop up.
VBA code. I think I need a worsksheet change event. Here is what I'm looking for:
If cell K1 = 3 and if the value of any cell in column A is < 80000 or is > 86666, or if the five digit number begins with an alpha, then a msg box will pop up stating "Invalid range".
More background:
The user will be manually inputting 5 digit numbers into column A, but if they've selected cell K1 to equal 3 from a dropdown menu (which the user also does), then values entered that are less than 80000 or greater than 86666 are 'out of range', and the user should be alerted and if possible the number they entered gets cleared.
Additionally, some of the numbers the user could type in might begin with an alpha prefix, such as "G1234" - these would also be considered out of range when K1=3, so if the conditional statement could also recognize this it would be useful.
Column A will be blank until the user types in the 5 digit number, so the code only needs to trigger if the number typed into a cell in column A is outside of the aforementioned range.
So to sum it up once again, I'm looking for a msgbox (and clear cell) if the following criteria is simultaneously met-
*If K1 = 3 (meaning that K1 equaling anything other than 3 wouldn't cause the msgbox)
*And values typed in column A are less than 80000 or are greater than 86666, or begin with an alpha (meaning that values typed in between 80000 - 86666 wouldn't cause the msg box.)
I am trying to perform a calculation in a cell that leaves the value 0 if before Feb 2014, changes to the value of another cell in Feb 2014 and leaves the value unchanged if after Feb 2014. I can get to the Feb 2014 value but after that month the value changes to 0.
The Cell formula that I am trying to use is as follows:
=IF(YEAR($A$3)<2014,"0",(IF(YEAR($A$3)>2014,H114,(IF(MONTH($A$3)<>2,H114,AA118)))))
A3 contains TODAY()
H114 is the cell being calculated
AA118 is the cell containing the calculated value for the current month.
I would like to try and achive a conditional format that will require a lookup function. when the condition is met it places Yes or No into a cell and changes that row colour to red for the NO condition. and after 10 days from now the rowcolour is removed.
View 6 Replies View RelatedHow do you add icons into a message box. ie a warning triangle etc.
View 3 Replies View RelatedI'm having trouble with the two formulas working in conjuction with each other.
Condition 1:
=(MOD(ROW(),2)=0)*(COUNTA(3:3))
Condition 2:
=TODAY()>=A1
"Condition 1" seems to override "Condition 2"? Ever see that?
So I have one sheet that needs to pull data through to another sheet (which is a stats summary)
I have a drop down list containing 4 options all of which have to be counted separately on the stats summary sheet. However I only need them counted when a value is input in another cell in that row.
For example: I select option 1 from down down menu, but I only want this to be counted on the stats page when I enter a date in the "date" cell.
Here's a simplified example:
ColA
ColB
ColC
Row1
A
Y
A
Row2
B
N
D
[Code] .........
I'm looking to return the values in column A adjacent to the cells in Column B equal to "Y". The kicker has been returning only the cells where the condition is true. Column C displays the desired behavior.
The closest I've been able to get is with a simple IF statement but I'm pretty sure the answer is a far cry away from there and likely requires an array formula. I'd prefer not to use VLOOKUP or OFFSET but will if the alternative is very complex.
I need cell (O4) to display days overdue or days remaining on an assigned task based on subtracting due date (M4) from todays date, but only perform days subtraction function if (M4) is not blank and only if task complete cell (N4) is less than 100.
Have the conditional blank cell figured out, but nesting another condition for the less than 100 complete cell. So in other words, I don't want cell (O4) to subtract days and display any error, irrelevant data if there is not any due date entered or the task is entered as complete...
So i would like a message box to appear upon opening that asks the user "Are you sure this is the most recent copy of this workbook?"
Click Yes would simply close the message box and allow user to continue
Click No would close the workbook immediately without saving and also without prompting to save ( i have =TODAY() function within the workbook so the workbook will instantly be different from the current saved file and will for sure prompt the 'Exit without saving' warning box
Office 365 is my setup if that makes a difference.
I need to trigger a message box if 2 conditions are met: A1>1 and A2>1 Message "Limit Exceeded".
On searching I've found some code but can't get it to work;
Option Explicit ....
I have the following spreadsheet
Column A-------------Column B------------Column C
Invoice No.-----------Part Number---------Classification
8200001733----------LX+150SV-----------9010.90.9000
---------------------SE+68763001--------8501.31.4000
---------------------GJ+1000-------------8528.30.8040
---------------------LX+150SV-----------9010.90.9000
---------------------GJ+1055-------------9013.30.2020
---------------------SE+2222-------------" "
---------------------GJ+67210------------8419.39.3311
---------------------GJ+100217-----------" "
What I need is two sets of VBA Code and 2 message boxes for the above scenario:
If Range C3:Last row contains a blank cell then Message Box ("WARNING: All items are not classified" refer too C6 and C8)
If Range C3:Last row contains "8528" or "9013" then Message Box ("WARNING: There is an FDA/FCC requirements for this file refer to C4 and C5 - create an Attachment from the scan folder and save as Attachment3-FDAFCC documents).
Is it, by any means, I can display the value of a cell adjacent to a match in a column range in a message box ?
I am searching for the answer to this question past 1 hour on the internet !
As part of a macro I would like to add a piece of code that will make a pop up window appear, something like: "Please open the file ABC"
Can someone tell me what code should I add to my existing macro ? (I have just recorded the macro as I am do not know coding)
I need a VBA script that will allow an input either Text or Numerical and then search an entire workbook (5 sheets) and find it. It would be nice if it posted the information on the 1st sheet from where the macro will be run, Then I could use VLOOKUP and retrive the rest of the information.
I have a workbook with a ton of Purchase order Numbers, Vendors Name, Work Orders etc... and I have to search through them regulary. I have used the FIND button and it works, but when I try to record a macro with it I get stumped. Im Sure this is easy for you GURU's that program for a living, but for me, well.....Lets just say I am at a loss. I have tried this:
Sub FindPON()
Dim MyPON As Variant
MyPON = InputBox("Please enter your search criteria")
On Error Resume Next
Range("frmParts").Find(What:=MyPON, Lookat:=xlWhole).Activate
End Sub
I do not want to use comments box or data validation
I want to use a macro
cells C14, C32, and C49 are drop down list
If user selects "MFRHTC" from drop down list in either one
I want a message box to pop up and end when user clicks the OK button
this is what I currently have but is NOT Working
If Not Application.Intersect(Range("C14, C32,C49"), Target) Is Nothing _
And Target.Count = 1 _
And Target.Select = "MFRHTC" Then
Msg = "Units will provide the following in order to have ammunition Fed Ex to HTC's " & vbCrLf
Msg = Msg & "" & vbCrLf
Msg = Msg & " POC" & vbCrLf
Msg = Msg & " Unit ship to Address" & vbCrLf
Msg = Msg & " Phone Number" & vbCrLf
Msg = Msg & "" & vbCrLf
Msg = Msg & "" & vbCrLf
Msg = Msg & "Input the required info in the Comments Box"
MsgBox Msg, vbInformation, "FED EX AMMO INFO REQUIRED"
End If
End Sub
When a workbook is opened, is it possible to have a "welcome" message appear before the worksheets can be accessed?
I would like to create a "message" and two boxes that say "enter your name" and "enter your password".
These will be dummy boxes, but the user wont know that
I have following code to pop up the message box, but it does not pop up itself, I have to run the macros evry time. Is there any solution.
All I want if in Cell "C20" has the message " Check your Margin" than the message box pop up and should have the message as defined in my below code. Also, is this possible that the message should come in one box.
Private Sub Find_Criteria()
Dim i As Variant
Dim FindRange As Range
Set FindRange = Range("c10")
For Each i In FindRange
If i = "PLEASE CHECK YOUR MARGIN" Then
MsgBox "a) Check Provisional Sum allowances and Discounts"
MsgBox "b) Check with Brian if a base price review was required and missed"
MsgBox "c) Check for double ups in Timberline"
MsgBox "d) Check all big ticket items in Timberline ie. Trusses, bricks, plaster, paint and Site Works)"
MsgBox "d) Check if any items were underpriced in the contract and provide feedback to Brian"
MsgBox "e) Review and discuss any allowances with me." & " "
End If
Next i
End Sub
I've got a Macro that, when activated, allows the user to cancel a demand and highlight that row red when completed, here's the
Sub Cancel_DMD()
Dim datatoFind, sRemark As Variant
Dim sheetCount As Integer
Dim counter As Integer
Dim currentSheet As Integer
Dim searchRange As Variant
currentSheet = ActiveSheet.Index
datatoFind = InputBox("Demand Number To Cancel {(}Ensure correct Demand No. entered{)}:")
If datatoFind = "" Then Exit Sub
sheetCount = ActiveWorkbook.Sheets.Count
I also need to insert a MsgBox that pops up before exiting. The MsgBox needs to be in two stages, the first will ask "Have you contacted the Demands Clerk to cancel?" with "Yes" or "No" buttons. If "Yes" is clicked, then the macro completes and exits, if "No" is clicked, then the sencond stage will appear.
I am wanting a pop up box to appear when a certain value is reached in my worksheet.
My worksheet is a schedule of training, and we have the same columns duplicated over monthly tabs, i want a message to appear if a certain column named " Trainers" has reached 30. Would this be possible? I would like it to pop up with what cell it is that has reached this number.
I ve a formula in cell A2 of Sheet1. Say now formula value is 10,000,002 (this will change based on other calculation).
What I need is, whenever cell A2's formula value will become greater than 10 M, following pop up message will be shown: ....
Is there a way to add a message pop up in Excel to say that whenever cell c9 is > than .90 the pop up message should say "Please create exception"?
View 9 Replies View RelatedI have a list of products ranging from A2:A28. I have a formula which randomly selects 1 product from this list.
=index(a2:a28,randbetween(1,counta(a2:a28)),1)
and it works fine.
My question is whether or not i can output the results of this formula into a message box?
Title: Your Selected Product Is:
Results: forumla above
Buttons: OK
I have a lot of links on my excel page, links going to videos. Everytime I click the link, I have this message :
"there might be viruses... are you sure you want to open this file?"
I know there must be a way to take this message off : I worked with it for months, and then it suddenly disappeared. But now that I formatted, it's back again
message box properties. i m using this
View 3 Replies View RelatedBelow is a message box with an input bar inside the message box. I am able to put a prompt message on top of the input bar but i am finding it difficult to enter another message underneath the box. I want to have the text "Continue?".
[Code] ......
This is what the promt message with the input box looks like : Untitled.png
So basically right underneath the input bar i would like to have the word "Continue?"
I would like a macro that prompts a user to title the first row of a worksheet. My coworker told me to use a message box with a defined input variable, but I have no idea how to do that.
View 14 Replies View RelatedIn my macro, can I make a message box pop-up if any cells in 2 different columns (in the same row) meet certain criteria?
More precisely, in any given row, if Column G is "0", and Column K contains, but is not limited to "out of stock", I need a message box to pop up saying something like "Please review line items showing out of stock". Then the user should be able to click OK and the macro will continue to run.