<div>
Hi,<br />
<br />
what is the Z?<br />
<br />
Regards
</div>


<div>
Kindly FTA for excel in which when date is selected we get the Request ID LRQ-QZ-1 , same i need in VBA , when we use date picker a date is recorded in a cell extracting date n month from that date value to be displayed as in attached excel.
</div>


Kindly FTA for excel in which when date is selected we get the Request ID LRQ-QZ-1 , same i need in VBA , when we use date picker a date is recorded in a cell extracting date n month from that date value to be displayed as in attached excel.

<div>
<div class="content wysiwyg-content">
I want the value LRQ-QZ-1 in which &quot;-Q1&quot; mean Q stands for year 1 stands month , 1= January , Q=2016, 2=Febraury,R=2017 Like this How to extract month and year from date and assign a alphabet &amp;&nbsp;&quot;-1&quot; should be increamenting in Excel VBA<br />
Kindly help me out in this
</div>
</div>


I want the value LRQ-QZ-1 in which "-Q1" mean Q stands for year 1 stands month , 1= January , Q=2016, 2=Febraury,R=2017 Like this How to extract month and year from date and assign a alphabet & "-1" should be increamenting in Excel VBA
Kindly help me out in this

How to extract month and year from date and assign a alphabet  in VBA

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.