+ Reply to Thread
Results 1 to 4 of 4

Macro to fill present date in selected cells

  1. #1
    Registered User
    Join Date
    09-14-2014
    Location
    Delhi, India
    MS-Off Ver
    Ms Office 2010
    Posts
    19

    Question Macro to fill present date in selected cells

    Hi,

    Could anyone please provide me the macro for filling date in selected cells in the excel.

    Example - I selected some specific cells in the sheet, then ran a macro. I want today's date to come in those cells.

    I am just a beginner in the macros. Would appreciate someone's help.

  2. #2
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,450

    Re: Macro to fill present date in selected cells

    if you select a few cells

    and typed

    Please Login or Register  to view this content.
    in the formula menu and pressed ctrl and enter.

    you would have a date in those cells

    If you wanted to fix that date you would need to copy, paste special values.

    As a macro:

    Please Login or Register  to view this content.
    Last edited by mehmetcik; 09-19-2014 at 05:54 PM.

  3. #3
    Registered User
    Join Date
    09-14-2014
    Location
    Delhi, India
    MS-Off Ver
    Ms Office 2010
    Posts
    19

    Re: Macro to fill present date in selected cells

    Hi mehmetcik,

    Thanks alot. it is working.

    Could you please also suggest me, if i setup macro with button in one sheet(Example. Sheet 1) and want to fill date on selected cells in another worksheet(Ex. Sheet 2) in a workbook. what do i need to edit in this?

    I tried it but it didnt worked out. I have attached the file, you will find button on sheet 1 only.

    Thanks for help.

    FILE_080814- date.xlsm

  4. #4
    Registered User
    Join Date
    09-14-2014
    Location
    Delhi, India
    MS-Off Ver
    Ms Office 2010
    Posts
    19

    Re: Macro to fill present date in selected cells

    Can anybody help with this?

+ 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] Run Macro and fill out cells , when country is selected.
    By abjac in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 06-09-2014, 11:41 AM
  2. Auto fill Data when date is selected
    By Oppy in forum Excel General
    Replies: 1
    Last Post: 07-27-2013, 07:30 PM
  3. Fill selected cells by selecting a value from a list
    By davejcohen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-17-2010, 04:33 PM
  4. Macro to fill cells when a value is selected from Drop Down List
    By TRJJK73 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-17-2009, 05:13 AM
  5. Auto-fill the selected cells without using macro
    By sachi.b@gmail.com in forum Excel General
    Replies: 3
    Last Post: 02-22-2006, 11:35 PM

Tags for this Thread

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