This seems like a very simple question but I can't find the answer that I'm looking for. I have a spreadsheet with a drop-down ( validation) list. Based on what the person selects, I then would like to have a message box to come that would direct them that certain cells then need to be filled in.
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 be entered into our accounting software but that doesn't appear to be happening in some cases.
Is there a way that a pop up message can appear when column G is populated (Entered by)? Something like, "please be sure to enter this XYZ".
I have an excel file with many worksheets. I want to get a pop up message providing definitions of different subjects when they are entered from a drop down list in a specific range within a column to improve the users understanding of the subjects.
Worksheet 1 Range (where I want the pop up message to be valid): J85:J385 Subjects from drop down list in specified range: "x,y,z" Pop up message: "Definitions of x,y,z"
Do I have to make a new module, or write the macro in the selected worksheet? What should be the settings of the macro (general, worksheet, declarations etc.)
but i need to somehow incorporate a formula that only shows this if a cell has a value present.
I know as an example its something like:
=IF(C2="","",C3)
but i dont know how that would go in my existing formula as i dont know how to stack IF statements?? (a very kind person on this forum did the original formula btw)
the cell that i need to have as the 'blank or not' is D4.
I have a userform for entering a sales invoice onto a spreadsheet, it obviously has a textbox each for the net value(textboxnet), gst tax(textboxgst) and total value(textboxtotal). How do I get the total amount textbox (textboxtotal) to automatically sum up as I enter the net (textboxnet) and gst (textboxgst) amounts?
I am trying to do in the title so here it goes. I want a user to be able (on form 1) to enter a list of codes that refer to specific requirements (e.g. code PB114 may mean the user needs to perform a pressure test) and then excel will automatically display the requirement somewhere below. It is going to be somewhat of a database. In otherwords lets say in cell A1 you type in a code, e.g. PB114. In a range of merged cells or somewhere below that cell I want the information "Perform a pressure test" to appear.
My colleague in accounts has a sheet that lists all the invoices and values and other 'accounts department things' that I know little about.
Anyway, she has to manually input all the invoices she receives onto this excel document but sometime receives duplicate invoices (& inputs them twice be accident).
Is it possible for someone with macro skills to create a macro to run in a worksheet so that if she enters a number in a given column more than once an alert box appears to tell her. I've summarised the 'rules' below*
*Can is be written so that I can edit which column the alert is based on?
[In (for example) column F is a list of invoice numbers - all unique]
If user types a number in column F that matches a number that already exists, show alert box "THERE APPEARS TO BE A DUPLICATE ENTRY IN COLUMN F"
====
Any further clarification, let me know i'll try to post a blank sheet if my boss lets me.
I have a picture on sheet 2. When I enter the text "htfo" without the quotes into cells a1 on sheet 1 , i would like the picture to be displayed for 5 seconds and then exit the picture and return me to sheet 1.
in column A of a spreadsheet a date needs to be entered manually, however i cannot have it so it can be backdated or a weekend. I have seen a message box pop up if you try and enter a date prior to today saying , Please enter todays date , then gives you an option Retry Or Cancel. But im not familiar with this function.
Is it possible to have this if a date is enter and is either a weekend or a date less than today ?
I want to sort the information that will be displayed in a message box just before it's displayed, is this possible. I can't do this in the worksheet because it would conflict with how I have the worksheet sorted already. Here's the last portion of the code that will display what I want in the message box. I want to sort by the... Requested on: " & mpNames.Cells(i, 2).Text & " this column has a date and time in it and I want the sort to use this information to sort the message box.
If .Cells(i, "A").Value = mpTestName Then
mpMessage = mpMessage & mpNames.Cells(i, 1).Value & _ " (Requested on: " & mpNames.Cells(i, 2).Text & ", Leave type: " & mpNames.Cells(i, 3).Value & _ ", Start Date on: " & mpNames.Cells(i, 4).Text & ", End Date on: " & mpNames.Cells(i, 5).Text & ")" & vbNewLine & vbNewLine
End If Next i
If mpMessage "" Then
MsgBox mpMessage, vbOKOnly + vbInformation Else
MsgBox "Blah Blah Blah Blah Blah Blah Blah Blah", vbOKOnly + vbInformation End If End With End Sub
When the user enters a date (A1), that date is cross-referenced with a database to determine 1 of 3 results, in which the results are displayed in A3 as follows - Date out of range. (value="DOR"), No records exist. (Value="NRE"), Records exist. (Value="RE").
Once the date is entered and the corresponding value determined, I would like to have a ppo-up message appear with options:
Date out of Range. Message: "Date falls out of range of operating season. Please re-enter." ** I think I can use validation to take care of this. **
Message "Would you like to import data?" Yes - open external application No - default A1 to current date and await user input
Records Exist. Message " x Diamond Records; y Field Records; z Court Records " where x y z are numeric values based on lookup from the referenced database Message "Proceed to data" Yes - takes used to next new worksheep No - default A1 to current date and await user input
How / where do I code this to activate after the user enters a valid date?
I am looking for is VB code to firstly have a message box with an input box on (that bit i can do). The text and number put into the message box is then used to search the table for the information that relates to it.
The ideal would be for the code to find the data and then copy it either to the clipboard or to a section of the workbook.
The tables I am searching can be put into which ever format is easiest. Below is an example table;
I have been using the GetOpenFileName method and a message box to return the filepath of a file and saving the filepath in a variable called Filepath. This worked just fine.
What I want to be able to do is display the the file path at any time in a message box, but not sure how to do this. I tried displaying the message box in a form and was going to look for some way to call the form, but the form does not return the message.
My code for this is as follows:
Module 1 Sub getfilepath() Dim filepath As String filepath = Application.GetOpenFilename(FileFilter:="All Files (*.*), *.*", Title:="Select a file") UserForm1.Show End Sub
Userform 1 Private Sub OkButton_Click() Unload UserForm1 End Sub...........
I am just having a problem where at the end of my macro, the macro is looking for a value in a cell and there is no value at the end of the game for it to paste so I get an error. Instead of getting an error, I would like the macro to display, "You win!", if cell e1 is =1, "You lose!", if cell e1 is =2, and "tie game", if cell e1 is =0.
I'm a novice at VBA and I want a dialog box to display a welcome message once the user opens the excel file (worksheet). I can write the code to display a MsgBox but I can't make it to display the MsgBox once the file is open. I'm learning VBA by trial and error.
I am using an input box to enter the value of column D. After the value of column D is entered, I want a message box that displays the corresponding data in column A and B. with the vba coding?
creating a .Find code to search a range on a sheet and then display each result seperately in a msgbox. An inputbox will be the value .find searches the range for.
the msgbox needs to be a vbyesno
VB: 'SEARCH CODE Dim myItem As String, myRNG As Range, NewLoc As String Dim Found As Range [code].....
I need a program for my user form such that it displays an error message. I have created an user form with employee name ,task and remarks.
I need a program in such a way if an user clicks the "submit" button without entering all the fields in the user form, an "error message" should be displayed.
The submit button has to work only if all the fields are filled by the user.
I have a spreadsheet and a macro that creates a new sheet and enters some data into the sheet. The user gets to make some changes to the created sheet and then prints it out. I was wandering if there was any way to have a message coming up every 10 minutes remindnig the user about the new sheet untill it was printed out and then the warnings would stop. Could anyone sugest a good way to do that?
I want to display a message box to user upon opening a file. When the message box is displayed I want to display two buttons.
Button 1 = “Continue” Button 2 = “Cancel”
If the user selects button 1 (“Continue”), I want the file to remain open and the message box will close. If the user selects button 2 (“Cancel”), I want the file to close.
There is one condition that must be met for the “Continue” button. The message contains some disclaimer information. When the message box first appears on the screen, the “Continue” button is disabled. To make the “Continue” button active, I want to add a Check Box to the Message Box with a caption that reads “I agree to the Terms and Conditions”. Once the user places a checkmark in the Check Box, the “Continue” button will become active.
I have a workbook that can open a URL into IE when a project number is entered in an input box.
What I would like to happen is that if the project number entered does not have a URL against it and the value is #N/A, then the message box will display "Project does not exist". However if the number does exist, I want a different message box to be displayed which is a yes/no box.
The code below is what I have tried which works fine if the cell value is #N/A but when it is not it throws an Run-Time error 13: Type mismatch
Code: Sub SearchPidsMessageBox() Dim Answer As String Dim MyNote As String
I've got a spreadsheet where i need the user not be able to save the workbook if there is a blank row in a range of task which run from A4-last cell with data entered.
I would like it to say that "the row will be deleted, please amend"
After the check has been completed or varified it saves
I m trying to input values of an protected cell and an error dialog will display. my question is how to invoke that error dialog through vba? i have attached that error dialog for your perusal, see .jpg attachment
i have a routine which loops through a range looking for past dates and when it finds one display the result in a message box in my testbook i only use 25 rows but it gets annoying having to click ok for every find....is it possible to collect all results and display them in the message box at one time?
Private Sub Workbook_Open() Dim Mycell Dim Rng Set Rng = Sheets("Sheet1").Range("B1:B25") For Each Mycell In Rng If Mycell.Value < Date Then MsgBox Mycell.Offset(0, -1).Value & " Is Overdue By " & Date - Mycell.Value & " Days, Take Action Now!", vbOKOnly, "Tasks Overdue" End If Next Mycell End Sub
