Name checkbox with vba

[ruud1957]

Dear forum,

In a userform are multiple checkboxes. The come in sets of two (yes or No)
If a checkbox is clicked (true) then a cell value in sheet1 = "yes"

Upon 'Initialize' I want the backcolor of one of two checkboxes to change.
To do this I've assigned an ID to every couple of checkboxes
For example:

The checkboxes in the userform are cb1 and cb2 etc.
When running this code I get an error 91, object variable with, etc..

Please help.
Or is there a better way to do this? Sure there is, however....

Regards, Rudy

[Norie]

Rudy

How/where/when are you setting a and b?

Are a and be the name of the checkboxes?

[mehmetcik]

Firstly if you have Yes No options then you should use option buttons. If any option buttons are within the same frame then only one can be selected at any time.

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[ruud1957]

Hi Norie and Mehmetcik ,

Thank you for your reply.
I've wrestled up and attached a version of the workbook.
Hope it makes any sence.

Regards, Rudy

[Norie]

Can you explain, in words, what you are trying to do?

[ruud1957]

Hi Norie,

Because there are about 80 checkboxes, I'm somewhat hesitant to write code for all of them seperately. So I've tryed coming up with a way to load the questionair-sheet, showing the result of an earlier checklist as to the buttons Ja, Nee and Nvt. (Yes, no, not applicable).

The checklist can be obtained via listbox2 through listbox1. Listbox2 give a choice of checklists ordered by date, related to a street address in listbox1.
From there on in, with that code slightly changed, I should also be able to make new checklists and fill them.

I've noticed that, because of the sloppy way I've wrestled up the Test.xlsm, the data doesn't exactly show up like it does in the original file. Sorry for that.

Regards, Rudy.

[Norie]

Rudy

Do you have a list of questions somewhere?

[mehmetcik]

I have created a simplified Userform for you to study.

Please Login or Register  to view this content.