I need simple Macro - VBA

$2-8 AUD / hour

Completed

Posted

almost 6 years ago

$2-8 AUD / hour

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

Project ID: 17128317

About the project

9 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@cgullapalli

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 in 1 day

5.0

(930 reviews)

8.1

9 freelancers are bidding on average $10 AUD/hour for this job

@schoudhary1553

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. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,

$8 AUD in 40 days

4.9

(354 reviews)

8.0

@Teloquence

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 in 4 days

4.9

(335 reviews)

7.7

@avinav606lx

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 to discuss project , timeline and budget. Thanks A

$16 AUD in 3 days

4.9

(173 reviews)

6.5

@TechnoGuruu

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 today's date whenever there is any change in cell value. We can achieve that. Please allow me to work on your project. Thanks, Peter

$15 AUD in 40 days

5.0

(86 reviews)

6.1

@vlayausa

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

$7 AUD in 1 day

4.9

(140 reviews)

5.8

@nelumindralal

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 Thushara

$11 AUD in 1 day