chhavibhargava
New Member
- Joined
- Jul 3, 2020
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
Hi all,
I am creating a form using the ActiveX buttons.
My form is already up and running. I only want one more addition to it.
When submitting the form the an automated invoice number gets generated in the database, which is protected sheet and cannot be viewed by anyone except me.
So, what I want is that when I click the submit button it shows a pop up msg box generating the same database invoice number, so that, people filling the form can note down the invoice numbers.
Please help with the VBA code for the same.
I am creating a form using the ActiveX buttons.
My form is already up and running. I only want one more addition to it.
When submitting the form the an automated invoice number gets generated in the database, which is protected sheet and cannot be viewed by anyone except me.
So, what I want is that when I click the submit button it shows a pop up msg box generating the same database invoice number, so that, people filling the form can note down the invoice numbers.
Please help with the VBA code for the same.