RAKESH230583
New Member
- Joined
- Jan 10, 2011
- Messages
- 46
Hello Friends,
I have one userform used to collect periodic data, Wherein with the help of Application.Username I am able to extract the user details.
But is there any way that we can get the unique ID reference no. on every time the user form is filled and submitted by the user.
Post user save (Command tab) the userform - Message to show with Unique ID reference no . and then after user click on OK the same must be saved on Sheet1 (Data Dump) on Column B.
Example :
21032018001
21 - Date of submission
03 - Current Month
2018 - Current year
001 - Sequence number of data saved on that day.
I have one userform used to collect periodic data, Wherein with the help of Application.Username I am able to extract the user details.
But is there any way that we can get the unique ID reference no. on every time the user form is filled and submitted by the user.
Post user save (Command tab) the userform - Message to show with Unique ID reference no . and then after user click on OK the same must be saved on Sheet1 (Data Dump) on Column B.
Example :
21032018001
21 - Date of submission
03 - Current Month
2018 - Current year
001 - Sequence number of data saved on that day.