Generate A Message Prompt

May 20, 2008

I am currently using the below to generate a message prompt. I have two questions that require assistance.

1. How can I furthur tweak it to show the value contains in the cell that correspond to the date?

For example in cell A2 contains date value; Cell B2 is the order number.

If the date in A2 matches today's date, the message prompt should carry Cell B2's value instead of B2 that is displayed as of below code.

2. Can I set the prompt date to be like 15 days after today's date?

Example: Today is 05/01. There will be a prompt if the date in cell A2 is 05/16.

Private Sub Workbook_Open()
Dim r As Range, ff As String, msg As String
With Sheets("Test")
Set r = .Columns(1).Find(Date, , xlFormulas, xlWhole)
If Not r Is Nothing Then
ff = r.Address
msg = msg & vbLf & r.Address(0, 0)
Set r = .Columns(1).FindNext(r)
Loop Until ff = r.Address
End If
End With
MsgBox IIf(Len(msg), "Matches Found:" & msg, "No match found")
End Sub

View 9 Replies


Prompt Message Box Of The Time Remaining

Aug 1, 2008

I am making a break timesheet. My UserForm contains Start and End Time button. User clicks start button, a message prompt will appear containing the time he needs to be back in taking his break. The start time of his break will be pasted on the worksheet.

After that, user needs to click the End button to paste the end time he returned. A message prompt will appear stating the remaining time of his break if he comes before the allotted break time say " You still have 00:15:00 left" click "Yes" to end break click "No" to continue your break." If the user click Yes, the time he click the button will be pasted on the worksheet.

Here is the code I have but I am receiving error message "Method 'Range of object_Global failed":

View 11 Replies View Related

Message Prompt If There Is Blank Cell

Jan 19, 2012

I have a sheet that has vast amount of rows and all I need is for a message prompt to appear if there is an empty cell in columns A to E and if possible the blank cells reference number to be displayed in the message prompt?

View 9 Replies View Related

Stop Warning Prompt/Message

Aug 15, 2006

I have a macro here that turns exported text into delimited text, but it keeps prompting the user "Do you want to replace the cells"...can I somehow automatically bypass this prompt and always say yes?

View 2 Replies View Related

Keep Code Running When Message Prompt Shows

Mar 1, 2008

I have code to open another workbook and run a specific macro. I plan to then take that and copy it over to my workbook.

The problem I am encountering is when I run this macro, at the end of the code, a form/msg pops up stating it is complete. This then automatically stops my code from running (from my original workbook). How do I close this form in order to keep my code running?

View 3 Replies View Related

Excel 2003 :: Generate Outlook Message?

Sep 16, 2013

We have an Office issues spreadsheet where our staff post questions/issues they have. These items are then allocated to a member of staff to look into and resolve. Each issue is entered on a seperate row on the spreadsheet, with the issue in column C, the allocated persons initials in column H, their e-mail address in column I (pulled in from a look-up table based on their initials), and the response required date in J.

I would like the spreadsheet to automatically send an e-mail when the issue is allocated to a person, or is re-allocated to someone else, ie when the 'allocated to' cell changes.

The e-mail message would only need to inform them that an issue on "column C text" in "filename" has been allocated to them and that a response is required by "column J date". We use Excel and Outlook 2003.

View 1 Replies View Related

Macro To Generate Message Box Based On Colour Of Cells On A Sheet

Mar 29, 2007

I have built conditional formatting into some cells on ' Sheet 1' and would like a message box (saying "Check errors before closing") to appear when the user tries to close the workbook if any of these cells are coloured red (ColourIndex 3).

View 3 Replies View Related

Prompt Message Of Time Limit When Time Is Entered

Jul 30, 2008

Is it possible to place a prompt message regarding the time limit or return time when entered time is place on the worksheet? Like "Please be back at 8:30 AM" when the user click the Start time button at 8:00 AM.

View 10 Replies View Related

Placing Icons With Message In Message Box

Jul 11, 2009

How do you add icons into a message box. ie a warning triangle etc.

View 3 Replies View Related

Prompt And Populate

Jun 3, 2009

In column L on sheet1, I want the user to type in a number. That number will be the number of recommendations that need to be done.

Once "L" is populated I would like the user to be prompted to fill out
-what the recommendation is
-date in should be finished by
corresponding to the number that was typed into "L" which would be listed onto a new sheet. So if the user typed in 3 - I should have 3 recommendations with dates.

On my new sheet, I would like "A" to match "A" from sheet1 for the first one only
"B" would be the recommendation from the prompt
"C" would be the date of that prompted recommendation

Name - Recommendation 1 01/01/10
<blank> - Recommendation 2 02/02/10
<blank> - Recommendation 3 02/03/11

View 2 Replies View Related

Prompt Row To Delete

Mar 19, 2012

Is it possible to prompt the user for a specific row number to delete in a vba textbox? If yes, then the code would fire using a button. I have the worksheet protected and only want to unprotect through code to delete a specific row number, then protect it again.

View 5 Replies View Related

Insert Row Prompt

Oct 10, 2007

I'm in search of a way to prevent people who use a spreadsheet of mine from screwing up formulas. I've hidden rows 10 and 12 in a spreadsheet. i have a TOTAL formula in a cell on row 13 that counts from 10-12. that way, when people insert rows, the total is always right. problem is, people somehow seem still screw it up.

I'm hoping there's a way for me to put a button on the sheet to insert rows. and when the button is pushed, be promted to enter a number of rows. then have it insert that many rows.

Is that feasable?


View 9 Replies View Related

Using Input Box To Prompt For Name

Jun 17, 2008

I've not used Input Box function before. When a user opens my workbook I want to check whether a named range ("Name") is blank and, if it is, to prompt the user to type their name in an Input Box which then returns that value to the named range. This is what I have tried but I don't think I am referring to the named range correctly,

Dim strName
If IsNull("Name") Then
strName = InputBox("Please enter your name", "Name Required", "1")
Range("Name") = strName
End If

View 9 Replies View Related

VBA Re User Prompt

Oct 4, 2008

I have created an addin that runs several macros. To enable the user to undo any changes, I keep a backup prior to them using any of the macros in the form of a worksheet named back00xx. I want a prompt to be displayed to the user to remove these backups at the closing or saving of the file. The problem is that as an addin, how do I get it to display this prompt as the open workbook is not part of the addin.

Could one have a looping routine that is checking every xx min/sec to check if the current workbook contains any sheets starting back00

View 9 Replies View Related

Prompt Where To Save

Jan 10, 2007

Currently I have information that includes numerous distributors information on one sheet. The code below separates each distributors information into a new tab and a new workbook, names the workbook and saves it in the specified file path.

I am trying to figure out a way to use an InputBox to popup and ask the user where all the new workbooks will be saved at. Thus, avoiding the need to change the code each time you want the new workbooks saved in a different folder .....

View 9 Replies View Related

VBA - Prompt To Enter Data

Jan 15, 2007

After recording a macro that goes to last figure in data, how do I edit this to prompt for a new data value and enter it into 1st empty cell at end of data?

View 8 Replies View Related

Macro To Prompt Key In Date?

Jul 21, 2014

excel macros and only know how to record certain tasks, and then edit after recording the task.

I am working on a project to automate a daily routine task for a company which involves creating a new tab and inputting various datas.

How can I create a macro such that I create a new tab and a combobox appears asking me to input the date in a particular cell?

This is the first in a number of steps for fully automating this process.

So far I only have this to create a new tab.

Sub Macro1()
' Macro1 Macro
ActiveSheet.Copy After:=ActiveSheet
End Sub

View 1 Replies View Related

Prompt In Vba That Will Minimize But Be Available After The Choice

Nov 25, 2007

is there a way to make a macro that runs on startup
and prompts with a yes/no question, if the user
wants to multiply all new data values time 1.0825,
and after having selected if they do or dont want
to allow that, would it be possible to have the
prompt minimize itself but still be present in
case they decide to toggle that on/off?

View 14 Replies View Related

Input Box Prompt For Password

Dec 5, 2007

How The Vba Code Used For

My Excel File Name "eai.xls" ,when I Click The File , It Open The Sheet Name "menu" With The Inputbox Prompt:="put Your Id"
When The User Put The True Id , It Will Show The Input Box Prompt:="your Password" . If The Password True Will Activate The Sheet Name "data" .and Hide All The Menu Bar.

If The Wrong Id Name Show The "re Enter Your True Id " ,that Also For The Wrong Password In Which If User Put More Than 3 Times Wrong , Will Close The Workbook And Exit File.

The User Persons Allow 10 Person Id . Keep In The Table Of The Sheet Name " Id And Password" The Id No. Are In The A1:a10
Password No. Are In B1:b10
This Sheet Name Is Hide And Protect

View 14 Replies View Related

Ignore Input Prompt

Apr 18, 2008

I run a macro to open multiple workbooks and run a macro within those workbooks. All worked fine until a message/input box was included in the individual workbook macros [that I cannot change] to notify the single workbook user when the macro had successfully completed and prompts for an “ok” input.

Can I get my macro to ignore this prompt and not wait for an input – I am currently clicking “ok” everytime it comes up on screen. Have searched help and forum but nothing jumps out.

View 9 Replies View Related

Input Prompt Page

Sep 10, 2008

I have eventually got my Worksheet up and running but now im trying to make things a little easier to complete. The plan is when the Engineer is on site he has to open the Excel sheet to check the tests he has to complete and then mark the results. this is fine but for vaildation he has to sign everthing etc... i made it easier so they only had to fill in one box and it would complete the rest but this seems to get missed more often than not.


i want a Screen to pop up when some one opens my excel that says Enter name and contact details. then they submit this which updates the spread sheet with this information and then the engineer can continue as normal.

View 11 Replies View Related

Validate A Value Entered Through The Below Prompt

Aug 18, 2009

What is the best option to validate a value entered through the below prompt?

View 4 Replies View Related

Prompt For New Active Cell

Nov 21, 2011

Is there a way for VBA to prompt the user for a new selection?.

For exmaple,

Sub BlankRow()

The reason I need this is because I am already in a macro and can not change selection on screen and I don't want to exit routine to make new selection (last line of code).

'I need to be able to select new active cell!

ActiveCell.EntireRow.Interior.ColorIndex = 1
ActiveCell.Offset(1, 0).Select

End Sub

View 2 Replies View Related

Update Values Prompt

Feb 12, 2013

I attempted to copy the cells (which had formulas) from one workbook worksheet into another workbook worksheet. It didn't paste properly, so I deleted it and resolved to enter the formulas I needed manually one by one. The formulas reference values in other worksheets within the same workbook. The issue is, now, for some reason when I attempt to enter the formulas, I get an "Update Values" prompt and the formulas won't reference the sheets within the same workbook anymore. Is there a way to stop this prompt from appearing? and unlink the workbooks?

View 1 Replies View Related

VBA Password Prompt Keeps Popping Up?

Dec 13, 2013

The VBA password prompt keeps popping up when I closed my workbook even though I haven't opened up the VBA window. How do I stop this?

View 1 Replies View Related

Prompt For Save When No Changes Made

Dec 10, 2004

I have an excel spreadsheet that when opened and closed prompts to save changes, even when no changes have been made.

The spreadsheet is a copy of another spreadsheet which has then been modified. The original spreadsheet doesn't have this quirk.

There are no 'links' in the spreadsheets. Which was my first thought.

View 9 Replies View Related

Suppress Protection Prompt

Oct 25, 2007

Is there a macro to supress the popup prompt saying "the cell is protected...." when users double click on a protected cell ?

i prefer for nothing to happen when users double click a protected cell..

View 9 Replies View Related

Conditional Error Prompt In VBA

Mar 31, 2008

I have a macro used to format data from a software export. The user exports data from another system, copies and pastes the values into my sheet. I have a macro set up to strip out unneccessary columns, format everything, etc. The problem I'm having is that people keep clicking the macro button multiple times, which deletes more columns, and strips useful data out. Is there a way to set up a flag in the macro to stop them from doing this?

Once the sheet is formatted, it types in "Imported ____" (where the blank is the current date and time). So I'm thinking that is the best option to flag the macro; if A1 contains Imported*, then prompt "don't touch that friggin button"....or something to that effect.

Here is the code I have:

Sub Formatting()
' Formatting Macro
' Macro recorded 3/27/2008 by mileskb

View 9 Replies View Related

Override Prompt From Another Macro

Oct 12, 2009

I have a macro that performs an operation on all Excel files in a given folder. The only problem I had was I couldn't walk away until it was done because the files themselves had macros that gave me a Yes/No prompt to recalculate.

I already have a calculate command in my macro so how can I override this command without physically selecting and clicking "No" with my mouse and without editing the macros that are already in the files (each unique and embedded in the individual worksheets). I cant edit each file because there are close to 300 of them.

View 9 Replies View Related

Stop Save Prompt

Feb 11, 2005

I have a spreadsheet that has hyperlinks in it and is mostly protected to prevent changes. Is there a way to prevent the "save changes" dialog box from appearing when this file is closed as I have to make this file available to others and don't want them to get this message or make save any changes.

View 7 Replies View Related

Copyrights 2005-15, All rights reserved