Double Click In Cell To Show Current Date And Time
I would like to be able to track progress of various tasks/occurences by allowing users of a spreadsheet to just click in the appropriate column and in doing so, it would fill in the current time and date. I.E. Column headings would read, "Item Sent to Review", "Item Received From Review", "Item Sent to Specialist", etc. and I want users to be able to double click in a given column to populate with current date/time information,
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Show Current Date In The Cell,but Tomorrow- No Change
I have a little problem (but for me is like a break); I want, when I change some in a cell, in the other cell, show me current date. I try with "today()", but , next day when I open that workbook, in that cell, show me the date coresponding with the next day (normaly). How ,I can rezolve this? I want to blocked that cell, only view, but no acces for change enithing.
View Replies!
View Related
Automatically Add Username, Current Date And Time Each Tiime Any Cell Is Changed
I am looking to have a macro which will automatically add the username and date to a cell, when the cell above changes (or in this case =x). I have a bit of code from a previous project, but I have changed Target.Row to Target.Column and it is not behaving as I require: Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Range("B2:BZ2"), Target) Is Nothing Then Range("C" & Target.Column).Value = Format(Date, "dd-mmm") & " " & Format(Time, "hh:mm") & " by " & (Application.UserName) End If End Sub See the attachment for the example. What I need is whenever row 3 ="x" I need the corresponding cell in row "d" to update with the latest date, time and username. Please not the macro is currently not active on the sheet as i've added the ' character.
View Replies!
View Related
Double Click Cell To Jump To Sheet
I have a list of numbers in column B of one sheet. these numbers are unique and randomly allocated to other sheets in the workbook. i would like a macro which when a user double clicks on a cell in the list of numbers .. the macro will jump to the sheet containing that number.. (i.e. do something like the find function)... I have some code below which might be useful for you but I can't work out what I need to write.
View Replies!
View Related
Launch UserForm With Double Cell Click
I've found the code below and tweaked to suit my needs but having trouble. Had it working one time. The code below calls a userform when the user double clicks on a cell. The form pops up and is not active/enabled. I cannot select anything on the form until I select a cell on the sheet, then everything on form becomes active/enabled. Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) 'check cells for desired format to trigger the frmSel_WBS.show routine 'otherwise exit the sub Dim NumberFormat, DF NumberFormat = Array("[Blue]General") For Each DF In NumberFormat If DF = Target.NumberFormat Then frmSel_WBS.Show vbModeless End If Next End Sub
View Replies!
View Related
Double-Click Cell Border Jumps To Other Cells
I'm trying to double-click a cell to edit the contents, and I am off a few pixels, it treats the double-click as a double-click on the cell border, not the cell contents, and the focus jumps to another cell in the direction of the border instead of going into edit mode. The effect is as if I had pressed Ctrl and the arrow in the direction of the border I clicked on. The only way I've found to disable this is to turn off the option "Enable fill handle and cell drag-and-drop", but unchecking that also disables actually useful things, like dragging the corner of a formula call to copy it down, etc. Is there a good way to disable this cell jumping when I accidentally double-click a cell border?
View Replies!
View Related
Add Diagonal Borders To Cell On Double Click
I have made a toggle button to turn diagonal borders on and off in a single cell. Is there a way to make the button transparent, such that the button can be placed over the cell itself and the contents of the cell will be visible underneath, no matter the condition of the toggle?
View Replies!
View Related
Have ComboBox Appear On Cell Selection & Double Click
I am looking for assisitance in combining the functionality of two seperate combo box code sets. The first combo box code set allows the combo box to automaticially appear when a user Clicks on a cell that contains a data validation list. The second set of code will have a combo box appear when a user Double-clicks on a cell that contains a data validation list. And the code allows for Named Ranges on a seperate worksheet. I would like to have the functionality of having the combo box to appear when a user Clicks on a cell and not having to Double-click. Also, I would like to have the option to use Named Ranges on a seperate worksheet ("Validation Lists"). Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim str As String Dim cboTemp As OLEObject Dim ws As Worksheet Set ws = ActiveSheet On Error Goto errHandler If Target.Count > 1 Then Goto exitHandler Set cboTemp = ws.OLEObjects("TempCombo") On Error Resume Next If cboTemp.Visible = True Then With cboTemp .Top = 10 .Left = 10 .ListFillRange = "" .LinkedCell = "" .Visible = False .Value = "" End With End If................
View Replies!
View Related
Open Message Box On Double Click In Cell
I am trying to make it so that when you double-click in a cell in column A, a message box opens populated with the text string in the corresponding cell (same row) in column Z. Seems to me like it should be easy enough, but despite spending the last hour searching for clues, I can't seem to figure it out.
View Replies!
View Related
Show Date/time Of When Cell/column Was Last Edited?
I have columns in my spreadsheet that will be getting updated periodically with a number. 1 week it might be 24, the next it might be 26.... and they would go in January's price, February's price.... The problem is, if a price is entered into the column, we don't know when it was entered other than the fact that it was entered in that month. Is there a way to show the date and time of when a number gets entered or edited in a cell? This date/time could perhaps show up in a column right next to it.
View Replies!
View Related
Run Macro On Double Cell Click If Cell Part Of Named Range
I have a sheet where i have many differently named areas (like state1_1 and state1_2) When I doubleclick on a cell then a macro should run with following criteria: 1) Macro will run if the doubleclicked cell is part of any range in the list. Here I mean that names of ranges which belong to that list start with word state (like state1_1 and state1_2). No other ranges should not be in that list. If the cell is not in the range that is part of the list, then nothing should happen.
View Replies!
View Related
Append More Than 256 Characters From Cell On Double Click To TextBox
if there is a workaround to this issue. I have this code that transfers data to a textbox but it stops after hitting the character limit. Does anyone know how to extend this limit ? Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Cancel = True With Me.Shapes("textbox1").TextFrame.Characters .Text = .Text & Target.Value End With End Sub
View Replies!
View Related
Double-Click Cell On Protected Sheet To Open UserForm
I have spreadsheet with client names. I'd like to build logic that will open a form with client information when a user double-clicks on the client name. But I have a couple of problems. - First, I'd like to protect the sheet and hide the formulas. But when I protect the sheet, I get the "the cell or chart you are trying to change is protected" error when I double click the protected cell. - If I deselect the "Select Locked Cells" options when I protect the sheet, I no longer have the ability to double-click on the cell. how I can double click on a cell yet not allow the user to edit the cell (or see the formula)?
View Replies!
View Related
Show Only The Date That Corresponds With The Current Date?
How do I get cell B1 to show only the date that corresponds with the current date? ex. A1 15-Nov 26-Nov 29-Nov 2-Dec 4-Dec 4-Dec 5-Dec 6-Dec If I enter 12/2, in one of the rows in column A it will display today dates in cell B1 since today is 12/2, but when tomorrows comes, since there is not a 12/3 date in column A, B1 cell will be empty, but when 12/4 comes, cell B1 will show 12/4 since that is a 12/4 date
View Replies!
View Related
Current Selected Cell On Click
I want to color a row of cells a certain color when the user clicks on one of 5 buttons. If it is the "Purple" button I want the current row colored purple. The row has 5 cells in it from 1 to 5. I am having trouble finding the answer to knowing what row the current selection is. I can't find a way to pass the current row, col data to my routine. BTW, I recently changed from Office 97 to Office 2007. How do I set the properties of the button? I tried right click and properties but that only brings up the Worksheet properties. The properties button in the menu bar only brings up a font properties dialog.
View Replies!
View Related
Add X Time To Current Date
I've been looking for an easy way to add time to a cell that has a time or date and time in it, for example, 5/31/2007 12:06:27 PM I want to add 30 minutes to it, for example, without having to split it apart and manually add it in, worrying about adding an hour if I go over 60 minutes, etc. If I was doing it with a cell formula, I could use "=A1 + TIME(0,30,00)" but I don't know what the equivalent would be in VBA.
View Replies!
View Related
Date And Time Update With A Click
Im trying to make an excel sheet as quick and easy to update as possible. Is there anyway to add an option ( formulated button,cell etc etc) that can update the current date and time in a desired cell with just the click of a mouse? This is for comunication as to when the info/count has been updated in the sheet.
View Replies!
View Related
Save Workbook As Current Date & Time
I'm trying to save a file with current date and time...I used the code from the following thread: Save File Name With Date/time Stamp ActiveWorkbook.SaveAs Filename:="C:FinalOutput.xls " & _ format(Now(), "mm_dd_yyyy hh mm AMPM"), FileFormat:=xlNormal, Password:="", _ WriteResPassword:="", ReadOnlyRecommended:=False, CreateBackup:=False Now when I try to run the macro, it gives me an error saying: Compile Error, Wrong number of arguments or invalid property assignment. And it highlights "format" in yellow.
View Replies!
View Related
Continually Compare Time In Cell With Current Time
I need a way to compare the time of the computer with the one in the cell and bring up a message box if the time matches. Yet i don't want it to be a one time makro. What i want is to be able to work with the worksheet and that at the same time i want a paralel function to check whether the time in the cell matches. Something like agenda in Outlook.
View Replies!
View Related
Format Date & Time To Show Day, Date & Time
I have a sheet with a list of dates in it that I wish to format to show the day as well as date and time. I am trying to do this automatically with a macro, below is the before and the desired after. Before Format - dd/mm/yyyy hh:mm Appearance - 29/03/2009 00:30 After Format - ddd dd/mm/yyyy hh:mm Appearance - Sun 29/03/2009 00:30 This works fine when I format the cells manually, but when I try to format them via macro '29/03/2009 00:30' becomes 'Sun 29/03/2009 12:30' which is obviously a totally different time! Has anyone got ay idea why it might be doing this?
View Replies!
View Related
Open With Double-click
I seem to have broken something!. Whenever I double-click to open an Excel file (.xls files are associated correctly), Excel opens, but nothing happens. That status bar says "Ready," but my workbook never appears. If I do a File-> Open within Excel, then I am able to open the workbook. I have no idea what is going on. This occurs for all Excel files whether they contain macros or not.
View Replies!
View Related
Double Click Range
I have a code for doubleclick on a cell and a gdt application chart will open. Private Sub Worksheet_BeforeDoubleClicK(ByVal Target As Range, Cancel As Boolean) ActiveSheet.Unprotect ThisWorkbook.Unprotect Dim i As Integer Dim gdt As Long Dim S As String Cancel = True With Application If Target.Address(False, False) "C11" Then Exit Sub 'Place your direct path to open this GDT application S = "C:Documents and SettingsUserMy DocumentsAndy's MachineINSPECTIONGDTGDT BitmapGD&T_Font.exe" If Dir(S) = "" Then MsgBox "File does not exist:" & vbCrLf & S, vbCritical, "Error" Exit Sub End If gdt = Shell("""" & S & """", vbNormalFocus) End With ActiveSheet.Protect ThisWorkbook.Protect End Sub What would the code be for a range of cells if doulbe clicked the range would be C11 thru C35 Also, I have a double click code for another symbol chart to open. How, would this be used in the same manner if a coulmn or row were to apply on double click.
View Replies!
View Related
Double Click Event
I am trying to write some questions on cells of Sheet1 of a workbook. Then I want to write the answers on cells of Sheet2 of the same workbook. I want the user to be able to double click the question-cell on Sheet1 and be taken to the respective answer on Sheet2.
View Replies!
View Related
Highlight On Double Click
here is what i am trying to accomplish: on the worksheet there are six ranges...each range has three columns...the first is team name, the second is rep name, and the third is the metric being measured. what i would like to happen is... when a team name is double clicked in any one of the ranges, i would like all three cells (team name, rep name, and metric) to be boldfaced and have the cell interior change color for all instances across all six ranges that match the team name double clicked. when double clicked again, it should go back to original formatting. likewise, when a rep name is double clicked in any one of the ranges, i would like all three cells (team name, rep name, and metric) to be boldfaced and have the cell interior change color for all instances across all six ranges that match the rep name double clicked. when double clicked again, it would go back to original format. so for example, if i happen to click on a cell in the team column in the second range for "team a", all cells in each range (including the adjacent cells for rep and metric) would be highlighted.
View Replies!
View Related
Reverse Before Double Click
I am trying to create code so that when a cell in Column C (for example C1) is double clicked, it makes the font bold, italicized, blue and inserts a row below the double clicked cell. I am also trying to make it so that if the cell is double clicked again, it removes the bold, italics, blue and deletes the row that was previously inserted. Private Sub Worksheet_BeforeDoubleClick _ (ByVal Target As Excel.Range, Cancel As Boolean) If Target.Font.Bold Then ActiveCell.Offset(1, 0).Rows("1:1").EntireRow.Select Selection.Insert Shift:=xlDown ActiveCell.Select Cancel = True If Not Target.Font.Bold Then ActiveCell.Offset(1, 0).Rows("1:1").EntireRow.Select Selection.Delete Shift:=xlUp ActiveCell.Select Cancel = True End If End If End Sub
View Replies!
View Related
Double Click And Copy Data
I have a sheet with some 300 plus rows of data. I use filters to sort through the rows to get down to anywhere from 8 to 10 or so rows. At that point I would like to be able to select (doule click) a filtered row of 10 cells (A:J) copy the data and paste it to a different sheet starting with cell B18. I want to be able to perform this process up to 5 seperate times. I have recorded a macro to do basically what I am trying but with many short falls. It only selects one row, I cannot double click on a row and it dosen't always paste to the proper cell.
View Replies!
View Related
Macro To Run On Double Click
I have populated a listbox from a filtered list and when 'Double Clicking' a name I want a macro to run. All seems to be OK apart from it is not finding/returning any data; I know the data is there and I think it may be the way I'm referencing the listbox value; Sub CopySignificant() Dim DestSheet As Worksheet Set DestSheet = Worksheets("Clients to Invoice") Dim sRow As Long 'row index on source worksheet Dim dRow As Long 'row index on destination worksheet Dim sCount As Long sCount = 0 dRow = 1...................
View Replies!
View Related
Looping Within Double Click Event
I would like to create a macro in which, when the user double clicks on a cell, that cell will be shaded yellow and other cells within the Workbook containing the same value as that cell will be crossed out. I have come up with the below code, but it doesn't work correctly. Any ideas on what I have done wrong? Would also like it to not cross out the cell the user double clicked on. Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean) Dim wk As Worksheet Dim selectedName As String selectedName = ActiveCell.Value With Selection.Interior .ColorIndex = 6 .Pattern = xlSolid End With For Each wk In ActiveWorkbook.Worksheets For i = 200 To 2 Step -1 If ActiveSheet.Cells(i, 2).Value = selectedName Then ActiveSheet.Cells(i, 2).Font.Strikethrough = True End If Next Next End Sub [/code]
View Replies!
View Related
Double Click To Enter User ID
i have some code that allows my users to enter their user ID on double clicking. The worksheet code below shows how on double clicking into Colum 3 (If Target.Column = 3 Then) then the user ID will appear. Q: How do i get the code to work in Columns 3, 5 and 7 but not those inbetween?! I tried using "or" but it allowed the ID to be entered into all columns! i.e. 3,4,5,6 and 7 which is not what I require. In short I need the ID to appear on double clik into every other column. Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim user As String 'This refers to the function ReturnUserName, which takes the name from the NT environment If Target.Column = 3 Then Target = ReturnUserName Cancel = True End If End Sub
View Replies!
View Related
SUM Function And Double Click
I have a spreadsheet that just uses the basic "SUM" function. This morning I went to use it and the function does not work after I change a number within the field of that function. If, however, I go into the SUM function and double click, then hit enter, it does the new calculation.
View Replies!
View Related
Double Click To Bring Up Form
I'm using a little sub routine to bring up a pop up calendar when i click in a cell, everythings lovely but it annoyingly comes up when i select a clolumn or row that also contains that cell. modification to require a double click to display the calendar?
View Replies!
View Related
Run Macro On Double Click
I want a X to be put in the activecell if empty or removed if already there. By searching this forum I found and read the article "Adding a Command Button to the Excel Right Click Pop-up Toolbar/Command Bar" and was able to add the code to do this to the right click sub menu. Is there a way to do the same thing by double clicking on the cell? This probably seems a bit nit pickey but I would just like for it to work using double click for my users. I wrote the following code to performe the action Sub Toggle_Macro() If IsEmpty(ActiveCell) = True Then ActiveCell.Value = "X" With Selection .HorizontalAlignment = xlCenter End With With Selection.Font .Name = "Arial" .FontStyle = "Bold" .Size = 12 .ColorIndex = 3 End With Else: Selection.ClearContents End If End Sub And placed the code below in Private Module of the Workbook Object.................
View Replies!
View Related
Show Date/time Between Entries
Basically each line signifies a date & time that a deposit was placed and a date & time that a withdrawal was actioned. My goal is to be able to determine what kind of average response time we have between the time a withdrawal was requested and the time a withdrawal was actioned.
View Replies!
View Related
|
TRACKER
