Results 1 to 2 of 2

Thread: Fill in the Date & Time automatically.

  1. Jun 15th, 2006, 03:54 AM #1
    Sentry11
    Sentry11 is offline

    Thread Starter
    New Member
    Join Date
    Jun 2006
    Location
    In my home
    Posts
    1

    Fill in the Date & Time automatically.

    Dear all:

    I have a worksheet which contains a column for the CURRENT day and time. What I would like to do is to have Excel automatically fill in the cell with the NOW() value upon selection of the cell. And I would like to confine this trigger to the entire A column only.

    Would some body be kind enough to tell me how to do that, with or without Macro or VBA. A small sub is needed I believe?

    Your help will be greatly greatly appreciated.

    Best regards
    Sentry11
    Reply With Quote Reply With Quote
  2. Jun 15th, 2006, 05:55 AM #2
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Fill in the Date & Time automatically.

    Moved to Office Development
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width