Just point me in the right direction

[bbaswell]

I feel kind of stupid for even posting here. I have been using Excel for years, but am just now trying to learn some of the VBA uses. I am not a programmer and that is the main problem. I have purchased the "Special Edition, Using Excel 2000" and have read most of the VBA chapters. They seem to give good explanations of what VBA is and how it can be used...but it doesn't seem to go into great detail as to the code needed for various functions and how to write that code. I am working on a simple test for my department that has an object box with 4 check boxes, a text box and a command button. Three of the four check boxes are required for the answer to be correct. When these three boxes are checked, I would like to have the text box read "Correct", and if any other combination of boxes are checked, I would like it to read "Incorrect". Clicking the command button should show the correctly checked three boxes.

I am not looking for someone to write my code for me, just tell me where I can go to see some examples of this kind of code so I can begin to learn this.

Any help would be apprecitated.

[Michelle Monty]

I am new to VB and found some books at the local library today to help. One I picked up but haven't looked at yet is "From VBA to VSTO, Is Excel's New Engine Right For You?" Author is Dr. Gerard M Verschuuren and the ISBN is 1-932802-14-2. This might help you. It looks like it has a lot of info in it.

I feel kind of stupid for even posting here. I have been using Excel for years, but am just now trying to learn some of the VBA uses. I am not a programmer and that is the main problem. I have purchased the "Special Edition, Using Excel 2000" and have read most of the VBA chapters. They seem to give good explanations of what VBA is and how it can be used...but it doesn't seem to go into great detail as to the code needed for various functions and how to write that code. I am working on a simple test for my department that has an object box with 4 check boxes, a text box and a command button. Three of the four check boxes are required for the answer to be correct. When these three boxes are checked, I would like to have the text box read "Correct", and if any other combination of boxes are checked, I would like it to read "Incorrect". Clicking the command button should show the correctly checked three boxes.

I am not looking for someone to write my code for me, just tell me where I can go to see some examples of this kind of code so I can begin to learn this.

Any help would be apprecitated.

[Graham35p]

I have found various ways to learn VB programming.
If you want to automate a sequence of events that you can do manually, start the Macro recorder, carry out your operations, stop the recorder then you can open the macro and look at the code. This can then be transferred to a larger program if required.

The Help files are also a good way to learn but it can be difficult finding an answer to your problem if you don't know any of the commands you need to use, but I find that if you keep trying you can eventually find something that fits your needs.
Another option is to get one of the '..for Dummies' books from the library or Ebay. They are available on most subjects and are useful for beginners and people who already have a bit of VB knowledge.