Note: The other languages of the website are Google-translated. Back to English
  Wednesday, 01 November 2017
  0 Replies
  2.6K Visits
0
Votes
Undo
i want to create a vba code that will upon double clicking a cell (A2:A9999) the current date and a two digit serial number (01 to 99) will auto-fill (20171031-01).

Example

Double click cell A2
-20171031-01

Double click cell A3
-20171031-02

Double click cell A4 (2 days later)
-20171102-01

I am new to this and i cannot seem to get it to work
There are no replies made for this post yet.

Follow Us

Copyright © 2009 - www.extendoffice.com. | All rights reserved. Powered by ExtendOffice. | Sitemap
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Protected by Sectigo SSL