Copy data from userform to sheet using option button
Dear developers,
In my form I want to make two types of invoices .The first type is for a simple invoice ,i.e :one item invoice and the other type is a multi item invoice .Is it possible to use two option buttons to set the source control for my controls in the form to enter data in the right cell: 1-Simple invoice:
from column 1 to column 12 2- Multi item invoice:
taking 1st and 2nd column and 6th and 7th then from column 12 onward till 63,64 and 65 as HT TVA and TTC columns.
I have seen many views ,but no reply which may imply that my idea is not clear .To summarize ,I have two forms and I want to make them one form only
The form is meant to make two types of invoices:
1-One item invoice
2- Multi item invoice
and at the same time I could be able to store data in "BDD" sheet is it possible? I am stuck in this problem for about one week.Please help
Herewith my file and I would be gratefull if someone could help.