Sachin Bhor
New Member
Hi Guys,
I am New in VBA - FILE ATTACHED
Login Id - admin
Password- admin@123
I need your help to create VBA code for below case/example
I have created userform for Raw material entries with below details
For Example -
SR.No - 1
Date Of entry - 29-Mar-2020
Supplier Name - ABC India Ltd
Material Name - Deisel Engine
Material Number - ............
Now Condition is I want to create Material Code automatically in userform for each material on the basis of material receipt as below
* Material Code For below Case should be - A100120B
1) Material name - Deisel Engine - A
2) Supplier Name - ABC india ltd - 1
3) Batch Code - for first batch - 001 (so on for remaining batches) -
Also i want create batch code for material automatically Like - Batch Code - for first batch - 001, 002, 003, 004, 005,006 (so on for remaining batches)
4) Year - 2020 - 20
5) Material Type - B
please guide me
Regards,
Sachin Bhor
Mail - sachin22588@rediffmail.com , sachinb22588@gmail.com
I am New in VBA - FILE ATTACHED
Login Id - admin
Password- admin@123
I need your help to create VBA code for below case/example
I have created userform for Raw material entries with below details
For Example -
SR.No - 1
Date Of entry - 29-Mar-2020
Supplier Name - ABC India Ltd
Material Name - Deisel Engine
Material Number - ............
Now Condition is I want to create Material Code automatically in userform for each material on the basis of material receipt as below
* Material Code For below Case should be - A100120B
1) Material name - Deisel Engine - A
2) Supplier Name - ABC india ltd - 1
3) Batch Code - for first batch - 001 (so on for remaining batches) -
Also i want create batch code for material automatically Like - Batch Code - for first batch - 001, 002, 003, 004, 005,006 (so on for remaining batches)
4) Year - 2020 - 20
5) Material Type - B
please guide me
Regards,
Sachin Bhor
Mail - sachin22588@rediffmail.com , sachinb22588@gmail.com