I need simple Macro - VBA

When a cell within a cell range is updated I need that cell value then to be overwritten and the value changed to today's date.

I still need to be able to delete that cell and clear it.

The code below doesn't work.

'Time stamp

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)

Dim cell As Range

If Not Intersect(Target, Range("A3:B100")) Is Nothing Then

For Each cell In Target

cell = Format(Date, "MM/DD/YYYY")

Next cell

End If

End Sub

Ικανότητες: Excel, Visual Basic

Περισσότερα: i need simple logo, i need simple app, I need simple poster, vba excel 2016, vba tutorial, excel vba programming pdf, excel macro tutorial pdf, vba excel 2013, excel macro examples, macros in excel for beginners, excel macros, data processing, excel, visual basic, microsoft office, visual basic for apps, microsoft excel, i need a macro wirtten and need a freelancer, i need simple dynamic app with 4 screen, i need a virtual assistant that can help with data entry and also customer services for my art gallery duties respond to custome

Σχετικά με τον Εργοδότη:
( 26 αξιολογήσεις ) Macgregor, Australia

Ταυτότητα Εργασίας: #17128317

Ανατέθηκε στον:


Hi, I am good at Excel and vba. I have reviewed the requirement. Please share the file to work on it and correct the program as per the requirement. -Chandra

$10 AUD / ώρα
(700 Αξιολογήσεις)

11 freelancers κάνουν προσφορά κατά μέσο όρο $9/ώρα για αυτή τη δουλειά


Hi, I can fix this for you. I am proficient with Excel and VBA and have a lot of experience with macros.

$7 AUD / ώρα
(128 Αξιολογήσεις)

Hi there, Your code is fine. You need to make a small adjustment. I can help you with that. Cheers, Mitch

$7 AUD / ώρα
(15 Αξιολογήσεις)

--Very Nice Job. Professional Excel, Visual Basic expert. Best result in time----- [login to view URL] I read your description very carefully. I am very interesting for your project because I have rich experiences and also Περισσότερα

$2 AUD / ώρα
(1 Κριτική)

Hello, I went thru the project description. This can be done by today, just 1 hr Kindly check my past projects and reviews Today can start. Looking forward to hearing from you Thanks Regards Thu Περισσότερα

$11 AUD / ώρα
(15 Αξιολογήσεις)

Excel expert at your service. Please check my past reviews for your reference. Looking forward for your reply so that I can start with the implementation.

$8 AUD / ώρα
(333 Αξιολογήσεις)

Hello, I can help with you in your project simple Macro - VBA. I have more than 5 years of experience in Excel, Visual Basic. We have worked on several similar projects before! We have worked on 300+ Projects. Plea Περισσότερα

$8 AUD / ώρα
(234 Αξιολογήσεις)

Hello there, This looks feasible and I can do this. I have developed more than 500 VBA macros for Windows/MAC I am an expert in Excel/Word/PowerPoint/Outlook VBA/Python with over 5+ years of experience. Ping me t Περισσότερα

$16 AUD / ώρα
(158 Αξιολογήσεις)

Hello, I have multiple years of experience in Excel, macros, functions, formulas etc. I have successfully finished multiple projects. From your project post I understood you that you want to update cell value to tod Περισσότερα

$15 AUD / ώρα
(15 Αξιολογήσεις)
$5 AUD / ώρα
(13 Αξιολογήσεις)
$8 AUD / ώρα
(24 Αξιολογήσεις)