+ Reply to Thread
Results 1 to 4 of 4

how to enter today's date into cell

  1. #1
    Forum Contributor
    Join Date
    12-11-2013
    Location
    St Moritz, GR, Switzerland
    MS-Off Ver
    Excel 2010
    Posts
    187

    how to enter today's date into cell

    I'm trying to enter today's date into a cell. What am I missing here?
    Please Login or Register  to view this content.
    Heads up: I haven't used Macros in eight years; don't be surprised if I ask you to simplify something if I can't figure.

  2. #2
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: how to enter today's date into cell

    What's not working? Only thing here is Now gives both a date and time, you can still format the cell to display only the date. If you want only the date value entered, use this
    Please Login or Register  to view this content.
    多么想要告诉你 我好喜欢你

  3. #3
    Forum Contributor
    Join Date
    12-11-2013
    Location
    St Moritz, GR, Switzerland
    MS-Off Ver
    Excel 2010
    Posts
    187

    Re: how to enter today's date into cell

    I'm getting error:

    Please Login or Register  to view this content.
    Last edited by johnandrews; 01-13-2014 at 04:43 AM.

  4. #4
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: how to enter today's date into cell

    So the problem lies on how objXLSSht is declared. Did you already declare it somewhere? If not, try adding these

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Simple macro to enter Today's date into specific cell
    By aaron.irvine in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-23-2013, 10:46 PM
  2. Replies: 3
    Last Post: 06-01-2008, 04:55 PM
  3. to enter today's date if a cell is blank
    By Lynn Hanna in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-26-2006, 08:10 AM
  4. in excel how do enter today's date on a laptop
    By bency in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 08-29-2005, 05:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1