Ολοκληρωμένο

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

Περισσότερα: 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, i need simple logo, i need simple app, I need simple poster, 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, i need a macro programmer

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

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

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

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 / ώρα
(700 Αξιολογήσεις)
0.0

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

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 / ώρα
(128 Αξιολογήσεις)
0.0
parsermonster

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

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

--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 Κριτική)
0.0
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 Thu Περισσότερα

$11 AUD / ώρα
(15 Αξιολογήσεις)
0.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 / ώρα
(333 Αξιολογήσεις)
0.0
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. Plea Περισσότερα

$8 AUD / ώρα
(234 Αξιολογήσεις)
0.0
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 t Περισσότερα

$16 AUD / ώρα
(158 Αξιολογήσεις)
0.0
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 tod Περισσότερα

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