Date Code For Input Into MsgBox

Feb 1, 2009

I have made a MsgBox which opens on Workbook opening with a message as follows:

View 4 Replies


Msgbox :: Will Change Upon The Input?

Feb 12, 2010

I have managed to get a inpubox into a sheet which takes in data and returns a particular value. Is it possible to get a msgbox to be returned displaying the particular value which will change upon the input?

View 9 Replies View Related

Msgbox And Input Box To Hide Columns

May 29, 2012

I have sheet with Oval button and when I pressed the Oval button input box appears and ask for password and I made msgbox if the password is wrong and I made loop 4 times to enter the password then after for trials will exit the inputbox ,But I have 2 problem with my code below

1st problem : when i press the cancel button before I insert any character in Inputbox the msgbox appears which its say the password is wrong

2nd problem : when i press the cancel button before I insert any character in Inputbox the column which the Oval Button exist on it disappear.


Sub Hide_Sal_Table()
Const pass As String = "123"
Dim Inp
Dim Retry
Dim lTries As Long
Inp = InputBox("please enter the password", "Zmhnk", vbOKCancel + vbQuestion)
Application.ScreenUpdating = False

[Code] ........

View 1 Replies View Related

Add MsgBox To Code

Jan 10, 2010

I want to change this so there is a MsgBox vbYesNo button below where it tells you what cells are found & says:

"Is this what your searching for?" If yes Box closes. If No Continues Search.
How would I go about adding it to the code below?

View 2 Replies View Related

MsgBox Does Not Appear After The Code Executes.

Jan 5, 2010

I have a code, which works, but I want msgbox appear after the code executes. But it does not.

View 5 Replies View Related

Execute Code While Msgbox Displayed

Sep 19, 2007

I have some code that launches a msgbox and I would like to have the code continue to execute with the msgbox displayed rather than wait for the user to click OK/Cancel.

View 9 Replies View Related

Msgbox That Will Prompt For Answer Before Running Code

Apr 28, 2009

I need a MsgBox that will prompt for a Yes or No response. If you answer Yes run the code below if you answer no just stop and leave me in the current sheet.

View 10 Replies View Related

Macro For MsgBox If Date Difference >10d

Nov 29, 2011

I have an application (in xl'97) where users enter a date in N4. =TODAY() is in C7 as the date of entry. I need some vba to show a message should C7-N4 be >10d.

View 2 Replies View Related

VBA - Validate Date Entered In Input Box Is Month Ahead Of Date In Cell

Aug 14, 2012

I have a input box that prompts a user to enter a date of a new month - it has to be the 1st of a new month. I have validation that it is a date that has been entered but then i want to validate the date entered is a month ahead of a date in a cell range on a sheet.

It is a monthly reset so it has to roll on from the previous month.

Here is what i have currently but it isn't working.


' Get user to input the first day of the new month to populate all dates with
dNewMonth = InputBox(Prompt:="Enter first Day of the new Month. Must be the 1st of the Month e.g. 01/10/2012", _
Title:="Enter Date")
' Validates the entered date is a valid date
If (IsDate(dNewMonth) = False) Then


View 1 Replies View Related

Fill Date Across Columns Based On User Date Range Input?

Mar 5, 2014

based on user date ranges entered on sheet1, I'm trying to write code that will write each month of the date range on other sheets across the 2nd row. at this point I'm getting "object required" error at "Set DateStart = Cells(2, 6)"

I also want the date format to be mmm-yy (Mar 14) on the sheets even if sheet1 has a different format. I tried using sourcerange instead of DateStart, but that didnt work either.


Dim projStartDate As Date
Dim projEndDate As Date
Dim DateStart As Date[code]....

View 1 Replies View Related

Retain Date Format For Input Entered As Date?

Mar 24, 2014

I'm using nested SUBSTITUTE formula to make some changes to the some of the data. I'm also using IFERROR to return the input if it does not find the criteria I have specified. I have lot of variations in my input data.

The formula works fine for all except for date format input.


12/3/1923---->58936 (I want the date to be retained)

why the date format is changed even if don't specify any changes for it. I expect my IFERROR to just retain the input as it is.

View 4 Replies View Related

User Input Date Not Kept In Date Format

Mar 29, 2014

My macro asks for a user input in DD-MM-YY format (which is the same format of all cells in the Excel worksheet).

I then instruct the macro to paste the string into cell A1 in 'TEST' sheet.

However when it pastes in the format is MM-DD-YY with the user input DD being the worksheet MM etc.

For example 06-04-14 becomes 04-06-14.

My code is below:

[Code] ......

Attached File : TEST.xlsm‎

View 2 Replies View Related

Control Code Input ?

Nov 7, 2008

Control Code input. I work with Autocad, when I extract data from a drawing into an Excel format (.xls) the extraction does not up date.

What I mean is:

In cad I input 6%%C L=7 and get 6 L=7. I need the excel file to convert as well. I need to program the cell? How?

View 2 Replies View Related

Security Code Input

Dec 7, 2009

If I have a cell which has been validated and has a drop down list of 4 names in it.
I need it to prompt the user that when they choose there name and select, a window pop up or similar window appears asking for a 4 digit(or similar) code.

This is to stop others using peoples names against jobs they have completed so there is accountability if there are issues with information.

For each line I need it to re-prompt the user to enter the 4 digit pin so it cannot be tampered with.

Can anyone help with sending through a form and VB code possibly which I can copy into my spread sheet or a method I can use!

View 14 Replies View Related

VBA Code Using Input Boxes?

Nov 7, 2011

I want to create some VBA code, but I don't know how to do it, that allows the user to make a copy of any worksheet he/she wants within a workbook and then name the copy of the worksheet whatever he/she wants. The copied worksheet should come at the end of however many worksheets exist in the workbook.

I want to accomplish this by using input boxes for the user. I want the user to click the macro and then the input box appears asking him enter the name of the worksheet he/she wants to copy. Then I want the input box to ask the user to enter name for the new copied worksheet. That's it!

A cancel button on the input would be nice just in case the user decides not to copy any worksheet.

View 9 Replies View Related

Input Box Result To Be Used In Code

Aug 4, 2006

I want to have a code where I can have an input box accept a value of text, such as aname and then use that value throughout my code, I will also be saving a file using that name

View 4 Replies View Related

Input Boxes In VBA Code

Aug 8, 2006

Not sure if this can be done, but a colleague of mine is trying to record a macro which is not cell or area specific, but content specific. i.e :copy only if cell A3:A10 = "rabbit", then paste in another tab cell B7:B14.

View 2 Replies View Related

Changing Vba Code With Input Box

May 10, 2007

Is there a way to change a line of vba code using an input box?

The current macro downloads a file from our intranet. However the filename changes each week. It is only the last portion of the filename that changes since this part is the date it is created. e.g filename010507.xls filename090507.xls

What I want to do is for an input box to pop up, the user then enter the date and this will then replace the existing filename in the code with the new date.

View 9 Replies View Related

Putting Input Box Into Existing Code

Jan 22, 2009

On the "If not Isempty" line, I am trying to input a box prompt. Instead of standardizing this macro, I want the user to be able to select a dollar amount to search and place on sheet3. Right now it works fine using 1.29 as the amount. However, I have other stores where this dollar amount is different, so I want the store managers to be able to choose an amount to search, for example 1.39, 2.99 etc...

View 2 Replies View Related

Modify Code To Have Popup Box For Input

Jun 12, 2009

I wanted to change a column text to call intial Caps. I found this macro code on the microsoft web site

Sub Proper_Case()
' Loop to cycle through each cell in the specified range.
For Each x In Range("C1:C5")
' There is not a Proper function in Visual Basic for Applications.
' So, you must use the worksheet function in the following form:
x.Value = Application.Proper(x.Value)
End Sub

I need to change the macro to have a input box (asking what column to convert text to initial CAPS)

View 9 Replies View Related

Colors The Zip Code That Matches The One Input

Aug 4, 2009

I am trying to build a simple spreadsheet for my salesman that given a customer's zip code, it looks up the corresponding territory code for that zip code. I have conditional formatting setup so that it colors the zip code that matches the one inputted, but how do I then return the value of the corresponding territory code. The spreadsheet being searched is a simple 2 column list, with the headings: Zip Code and Territory. What's the best way to get the territory code back to my worksheet?

View 9 Replies View Related

Compare Date: Compare The Date From The User Input And The Date Listed

Jan 18, 2007

I need to compare the date from the user input and the date listed on excel. How can I compare it? Is it correct? lngCmp = Val( Cells(I, 31))

Dim lngBegin As Long, lngEnd As Long, lngCmp As Date, lngResults As Long
lngBegin = 9 'beggining of data
lngEnd = 232 'end of data
lngCmp = InputBox("Please enter the date", "Begining of the week")

Lngcmp1 = DateAdd("d", 1, lngCmp)
lngCmp2 = DateAdd("d", 2, lngCmp)
lngCmp3 = DateAdd("d", 3, lngCmp)
lngCmp4 = DateAdd("d", 4, lngCmp)
lngCmp5 = DateAdd("d", 5, lngCmp)

'lngCmp1 = lngCmp + 1
'lngCmp2 = lngCmp + 2
'lngCmp3 = lngCmp + 3
'lngCmp4 = lngCmp + 4
'lngCmp5 = lngCmp + 5
lngResults = 0
lngResults1 = 0
lngResults2 = 0..................................

View 2 Replies View Related

Input Box Stops Rest Of Code Running

Jul 18, 2014

I usually just use macros to clean up Data from non-excel sources. So I wrote a macro to do this, but the process requires a date to be added, so attempted to do this via an input box. The input box works, but the code doesn't, clicking the button to which the macro is bound spits out an error 91 (object out of bounds?) when it hits the search function right after the inputbox code. Both bits work as intended separately, so I guess it's just some moronic formatting error on my behalf.

[Code] ......

View 6 Replies View Related

How Do I Input Zeroes In A Zip Code For A Mail Merge

Sep 6, 2005

Couple ways:

1) Format the cell as Text: Format->Cells->Text
2) Enter the zip code with a ' preceding the number, i.e. enter 00345 as
3) Enter the zip code with the formula ="00345" ...

View 11 Replies View Related

Code Not Working With Input Capital Letter

Jan 24, 2014

I have code that I just noticed will not work if user inputs a capital S. I have tried a few things but I can not seem to get it to work. Here was the original code:

If Range("H13") "s" Then

I tired this:
If Range("H13") "s" or "S" Then

View 3 Replies View Related

Code To Search And Select A Cell From An Input Box

Feb 23, 2007

I have a button set to bring up an inputbox. enter serial number.

What I need to do is enter the serial number and then have the macro look through a
single column of values to match it then go to that row.

This seemed so simple I thought I could get it but alas here I sit...

I have tried to search the forum for a similar code but haven't found one that was close enough to make sense to me. I have ut together alot of individual actions, but how to get the value inputed to "search" the column and once found go to that row.

I also need to make sure it accounts for new rows being added in the future. (no set row range)

View 9 Replies View Related

Vb Code Freezing At Line Input Command

Feb 26, 2007

I have created an AddIn for a project I'm working on using the 'Open' command in Excel Vb. While this worked perfectly for the file I was testing it on (1,740,754 bytes) it doesn't work on a new file (121,445,125 bytes).

On testing the code, one line at a time, it gets stuck on

Line Input #1, DataLine

The files only contain one line so I suspect there is too much data for the command to handle.

Is there an alternative?

View 9 Replies View Related

Creating VBA Code That Uses Input From Users To Create A Calendar

Sep 18, 2012

Modify Macro3 and use the InputBox function twice so that Macro3 would ask the user for a particular month and a particular year; and then Macro3 uses these user’s inputs to create the calendar template for that month of the year. For example, if the user enters February for the month and 2012 for the year, Macro3 would create a new


Sheets("Template").Copy After:=Sheets(1)
Sheets("Template (2)").Select
Sheets("Template (2)").Name = "January"


View 1 Replies View Related

Interupt Code For User Input: Move The Contents Of One Row To Another

Nov 2, 2008

Need way to interupt my code whilst the user selects a row. ie. if I wanted to move the contents of one row to another I would want to say: "select source row" (and want the user to click on any cell in that row) I could then put the rownumber in a variable with

View 2 Replies View Related

Code To Delete Rows Based On User Input

Aug 21, 2008

I am using the following piece of code to delete unwanted rows from a worksheet:

Sub DeleteDates()

FinalRow = Cells(65536, 3).End(xlUp).Row
For i = FinalRow To 1 Step -1
If Cells(i, 3).Value Like "*2007*"
Cells(i, 1).EntireRow.Delete
End If

Next i

End Sub

What I am working with is a sheet of about 5000 customer appointments going back to the beginning of 2006. A have peiced together a lot of code to format it exactly as I want and to create a pivot table of what is remaining after the rubbish has been deleted.

However I am finding that I need to keep amending and re-running this bit of code, depending on the date range I want to look at. For example the code above will delete all appointments made in 2007.

My question is: is there a way that I could incorporate an input box, whereby excel asks the user for a start date and an end date and deletes any rows outwith that range?

Some important info: All of the dates are in column C, in the format mmm yyyy

I would only need to narrow down to a month - so for example mar 2008 - jun 2008

View 9 Replies View Related

Copyrights 2005-15, All rights reserved