#Solved by Petr Radiměřský & Biplab Das Can anyone tell me how to fixed the date when i enter the value?

1 year ago 14 Replies
AR
Ataul Hasan Ranju
1 year ago

#Solved by Petr Radiměřský & Biplab Das

Can anyone tell me how to fixed the date when i enter the value? when i opened the excel sheet everyday then date has been changed automatically. but I would like to fixed the date when i put the value in d3.

7 Likes

Replies

Biplab Das 1 year ago

Ataul Hasan Ranju In comment section of the link download file:-

https://m.facebook.com/groups/393224307706029/permalink/914581282236993/?mibextid=Nif5oz

1 Like
Biplab Das 1 year ago

Ataul Hasan Ranju Can try also

0 Likes
Ataul Hasan Ranju (1 year ago)

is date will be changed if i open this file day after tomorrow.

Biplab Das (1 year ago)

Ataul Hasan Ranju In my way it will not changed

Biplab Das (1 year ago)

Ataul Hasan Ranju Check & Share Feedback

Petr Radiměřský 1 year ago

Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Columns(4)) Is Nothing Then Exit Sub Application.EnableEvents = False Cells(Target.Row, 1).Value = Date Application.EnableEvents = True End Sub

2 Likes
Ataul Hasan Ranju (1 year ago)

Petr Radiměřský Thanx it works. could you please tell me how can i put this in OneDrive excel sheet?

Petr Radiměřský (1 year ago)

Ataul Hasan Ranju If you mean a file opened via a web browser, then it is not possible. If you mean only saved on OneDrive and opened through a normal Excel application, then you can.

Ataul Hasan Ranju (1 year ago)

Petr Radiměřský Thanxxx a lot

Ataul Hasan Ranju (1 year ago)

Petr Radiměřský can i write this (Target, Columns(4),(5),(6),(7)) when data insert into multiple column?

Petr Radiměřský 1 year ago

Put this to sheet module

1 Like
Petr Radiměřský 1 year ago
2 Likes
Samir Shaker 1 year ago

Ataul Hasan Ranju you need Event handler for this.

Please follow the steps.

• Right mouse click on sheet bar > select 'View Code' • Cop paste the below code in VBA editor

Sub Worksheet_Change(ByVal Target As Range)

If Not Intersect(Target, Sheets("Sheet5").Range("D:D")) Is Nothing Then Target.Offset(, -3).Copy Target.Offset(, -3).PasteSpecial xlPasteValues Application.CutCopyMode = False End If End Sub

• Done. Now once you put anythisng in Column D, then Column A date will fixed

*Remember to save the workbook/excelfile as XLSM format

Text korun jodi kono question thake

0 Likes
Samir Shaker (1 year ago)

Ataul Hasan Ranju See the date in cell A3, once I put 1250 on D3, VBA fixed the date in A3