Formulas Help Please!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

if a4 has data of any kind how can i get f4 to Put the current time in it
hour:min:PM not with date
to view work book i am working to understand it more at
http://yourprintinghq.com/Payment.xls
it has comments on it for the formulas i am looking for

Thanx,
Paul M.
 
just right click the sheet tab>view code>insert this>SAVE.

Private Sub Worksheet_Change(ByVal Target As Range)
If target.row<4 or Target.Column <> 2 Then Exit Sub
Target.Offset(0, 4) = Time
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

workbook saved in different position 4
Supressing a #VALUE! error returned? 3
Use cell contents to make formula reference 4
looup help 2
if a4 has data how can i get f4 to Put the current time in it 1
Do loop or For Next with data from cells 1
Conditional Formatting Weirdness 2
Unknown Formula 5

Back
Top