Using Checkboxes and writing to a seperate spreadsheet.

[gjsala]

All,
I’m new to using check boxes and buttons. How would you have a list of check boxes(lets say 10) to select from and after selections were made you click on a submit button, this information would be written to an different excel spreadsheet on the C drive. After the information is written then the active excel spreadsheet would scroll to row 1000, column A and display “Your process is compete.” Thanks for your help in advance!

 

[SkipVought]

Hi,

Not explained very well.

One or more CheckBox are selected.

Then "this information would be written to an different excel spreadsheet on the C drive."

WHAT information?

WHAT spreadsheet? Is it ALWAYS the same one?

Please answer each of these questions clearly, concisely and completely.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[gjsala]

Skip,
Thanks for the quick response as I will go into more detail:
1.) There are 10 check boxes for me to select. I can select one box or as many as ten it will just depend on the situation.
2.) The Workbook with the check boxes and button will be, lets say, the main workbook then on the C drive will be another Workbook; we will call this the data workbook. The information from the main workbook will be transferred over to the data workbook on the c drive. I would like if check boxes 1 to 5 were check by me then on the data Workbook the information entered would have an “OK” associated with each box checked. If no box was check then that column would be left empty.
Check boxes 6 to 10 were checked then on the Data Workbook the information entered would have a “Look For” associated with each box checked. After the check box information is transferred then the Check boxes will be cleared. The main workbook will scroll down to Cell (100, 1) and display the following "Your data has been received". In Cell (101, 1) would display a button when pushed would move the main workbook back to Cell (1, 1) which is where the check box 1 is located.
3.) Data Workbook if I could have the information laid out as column 1 today’s date and time of entry, column 2 checkbox 1 information, column 3 checkbox 2 info and so forth. Each time I submit from the main workbook a new row is created.
Sorry about the last entry as yes it’s not very detailed and I must have grabbed the wrong entry I wrote in Word.


Thanks.

 

[SkipVought]

What code do you have so far?

Are you experiencing a code problem?

If so where?

What is the business case for this application?


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[gjsala]

Skip,
If I click on the button (Submit) on the main workbook spreadsheet how do I write the "true" statement from the checkbox selected to another workbook called Data in the first column and first row? Also how do I append more rows in the Data workbook worksheet? Right now I just have the form but I'm trying to learn how to take information from one workbook and input into another.
Thanks.

 

[SkipVought]

Are your check boxes LINKED to a cell on the sheet?

Are your check boxes FORMS or CONTROL TOOLBOX controls?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[gjsala]

Skip,
The controls are active X check boxes. As for linking check boxes to a cell on the sheet I’m not sure if we need too but my experience is very limited. What are your thoughts?

Thanks,
gjsala

 

[SkipVought]

How are you ActiveX controls named?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[gjsala]

The activeX controls are name picture1box for checkbox 1 and picture2box for checkbox 2.

 

[SkipVought]

Should I care about any controls other than the Combobox Control Toolbox controls?

What are the Combobox Control NAMES?

What code do you have so far?

Please answer EACH of these questions.


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}