Home |
Search |
Today's Posts |
#1
|
|||
|
|||
SELECTING CURRENT DATE AT OPENING
I have a worksheet with the dates of a month, say 1jan,
2jan, 3jan etc. Is there a way that excel by opening the workbook selects automaticely the current date. |
#2
|
|||
|
|||
Private Sub Workbook_Open()
Worksheets(Format(Date, "dmmm")).Activate End Sub in the ThisWorkbook code module. -- HTH RP (remove nothere from the email address if mailing direct) "R VAN DEURSEN" wrote in message ... I have a worksheet with the dates of a month, say 1jan, 2jan, 3jan etc. Is there a way that excel by opening the workbook selects automaticely the current date. |
#3
|
|||
|
|||
Thank you,
this one is usable to, what i mean is, selecting automaticely a cell with the current date -----Original Message----- Private Sub Workbook_Open() Worksheets(Format(Date, "dmmm")).Activate End Sub in the ThisWorkbook code module. -- HTH RP (remove nothere from the email address if mailing direct) "R VAN DEURSEN" wrote in message ... I have a worksheet with the dates of a month, say 1jan, 2jan, 3jan etc. Is there a way that excel by opening the workbook selects automaticely the current date. . |
#4
|
|||
|
|||
How about this, assuming that you give the name "SearchDates" (for example)
to the range of cells containing your dates. Sub FindCurrentDateCell() Dim SearchCell As Object For Each SearchCell In Range("SearchDates") If SearchCell.Value = Date Then SearchCell.Select Exit Sub End If Next SearchCell End Sub Hope this helps Pete Sub FindCurrentDateCell() Dim SearchCell As Object For Each SearchCell In Range("SearchDates") If SearchCell.Value = Date Then SearchCell.Select Exit Sub End If Next SearchCell End Sub "R VAN DEURSEN" wrote: I have a worksheet with the dates of a month, say 1jan, 2jan, 3jan etc. Is there a way that excel by opening the workbook selects automaticely the current date. |
#5
|
|||
|
|||
Sorry, I forgot you wanted to run it whenever the workbook opened!
Paste this code into the code window of your "ThisWorkbook" in the Visual Basic Editor. make sure you don't change the procedure name, otherwise it won't work. Private Sub Workbook_Open() Dim SearchCell As Object For Each SearchCell In Range("SearchDates") If SearchCell.Value = Date Then SearchCell.Select Exit Sub End If Next SearchCell End Sub In this way, the code will run whenever you open the workbook. I'm sure you know, but you can also have similar macros called: Private Sub Workbook_Close() which runs when the workbook closes, or Private Sub Worksheet_Activate() or Private Sub Worksheet_Deactivate() in the code windows of your worksheets to run when a worksheet is activated or deactivated. Hope this helps Pete "R VAN DEURSEN" wrote: I have a worksheet with the dates of a month, say 1jan, 2jan, 3jan etc. Is there a way that excel by opening the workbook selects automaticely the current date. |
#6
|
|||
|
|||
thank you,
this works great -----Original Message----- How about this, assuming that you give the name "SearchDates" (for example) to the range of cells containing your dates. Sub FindCurrentDateCell() Dim SearchCell As Object For Each SearchCell In Range("SearchDates") If SearchCell.Value = Date Then SearchCell.Select Exit Sub End If Next SearchCell End Sub Hope this helps Pete Sub FindCurrentDateCell() Dim SearchCell As Object For Each SearchCell In Range("SearchDates") If SearchCell.Value = Date Then SearchCell.Select Exit Sub End If Next SearchCell End Sub "R VAN DEURSEN" wrote: I have a worksheet with the dates of a month, say 1jan, 2jan, 3jan etc. Is there a way that excel by opening the workbook selects automaticely the current date. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
Calculating current age from 2 date cells | Excel Worksheet Functions | |||
Lock in current date | Excel Discussion (Misc queries) | |||
DATEVALUE OF CURRENT DATE | Excel Worksheet Functions | |||
How do I program a cell to automaticinput the current date as dat. | Excel Worksheet Functions |