PDA

View Full Version : Copy data from userform to sheet using option button



djemy1975
03-25-2016, 09:15 AM
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.

Herewith my file for further information.

Thanks in advance,

djemy1975
03-29-2016, 05:49 AM
Dear Friends,

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.

Thanks in advance,