| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
A formula or macro that will place the date in an adjacent columnB any time something is typed in column A
On Feb 26, 11:05*am, Dave D-C wrote:
This should be a start (using the SelectionChange Event): Private Sub Worksheet_SelectionChange( _ * ByVal Target As Excel.Range) * Dim iRow&, iCol& * If Target.Cells.Count < 1 Then Exit Sub * iRow = Target.Row * iCol = Target.Column * If iCol < 3 Then Exit Sub * If Target.Value = "" Then * * Target.Offset(0, 1).Value = Date * End If * ' or * If Target.Value = "" And _ * * *Target.Offset(0, 1).Value = "" Then * * Target.Offset(0, 1).Value = Date * End If End Sub ' Dave D-C Mike C wrote: Hello - I am trying to create a formula or macro that simply places the date in a column each time that I type in an adjacent column. I tried using =IF(A3="","",TODAY()), but it refreshes the today date each time I open the worksheet (thus not leaving the prior date in the cell. *Any ideas? Thanks for any suggestions.- Hide quoted text - - Show quoted text - Thanks Dave! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Place Date in One column when entry is made in another column. | Excel Worksheet Functions | |||
| Referencing date column A & time column B to get info from column | Excel Discussion (Misc queries) | |||
| Need Formula or macro. If i enter today date in the cell (Row 1,Column 2) and on tab out, the column 1 cell should be filled with "corresponding Day" of the date | Excel Discussion (Misc queries) | |||
| summing values from adjacent column with refrence from adjacent column | Excel Discussion (Misc queries) | |||
| How do place a column of date/time information into a calendar for | Excel Discussion (Misc queries) | |||
![Mike C[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
