Skip to main content
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
  Wednesday, 01 November 2017
  0 Replies
  4.7K 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.