Hello Experts,
I am working on a Data Analysis.
I have two worksheets named "Input Sheet" and "Data".
In Input sheet, I have 30 checkboxes which reflects if those 30 products are offered or not.
If Checkbox 1 is checked, it would mean Product X is offered.
Action required -
1. User will fill the Input sheet where I have checkboxes (check or unckeck) and then he will click radio button "Export Data".
2. A message box will be displayed - Do you confirm data export - Yes or No
a) If "Yes", export data and if "No", message box will disappear and it allows user to check his entries again.
3. On clicking this export data -
a) If in worksheet named "Input Sheet", user checks Checkbox1 for Product X, in other worksheet named "Data", change the value of cell $B$10 to 1; Else if it is unchecked then $B$10 should set to 0.
b) Similarly for Checkbox 2 map to WS Data C10, Checkbox 3 map to D10, Checkbox 4 map to E10 etc
Tricky part here is if User fills Input Sheet and export this by clicking on Export Data button, it should start filling data starting from Row 10 of Worksheet "Data". (Row 1 to 9 - I am using for some other representation).
Once the Export of data is done, reset all checkbox to unchecked.
If another user use the same file to fill data in worksheet "Input Sheet", this time when Button "Export Data" is Clicked, it should start exporting data in next row i.e. Row 11 and so on.
Request you to please provide VBA code for this exercise. I can understand that part of this module is possible with Form Control, but I wanted this to be implemented by Active X Control.
Also, please guide me if for this I have to assign macro on Radio Button or Input Sheet -> View Code.
Using Internet, I started with following sub module of code required. But even this gives an error.
Bookmarks