Hey,
I have been trying to ensure that one check box is ticked across a row. Each time I select the check box I receive the error "Run-time error 91 - Object variable or With block variable not set".. Please see code belowAny help will be appreciated.
Please Login or Register to view this content.
Nika
Do not declare the checkboxes. The fact that they exist is enough to reference them in your code. If you declare variables with the same names they will hide the actual checkboxes. Delete this
Please Login or Register to view this content.
Why are you setting CheckBox11 equal to itself, does the worksheet exist, are all the checkboxes on the sheet ?
I looked at your code again. You should be using option buttons instead of checkboxes then you don't need any of this code.
When I do not declare the variables I get a compile error message "Variable not defined"
I have attached the file for you to have a look. I was just trying the code with the first set of checkboxes and wanted to see if it worked. The user must check only on of the three in that row. This is a form that has been in use and I wanted to improve. If the option boxes would be better I will change as well. Just trying to improve the sheet before they start the new year.
Thanks for all the help.
Nika
I want the ticks to be row specific and when I use the option buttons I can only select for the entire group. I tried by assigning the option button to the another cell for that row but it didn't work.
Nika
You would create three option buttons for each row. If you use Forms controls you have to put each group of three into a Group Box. If you use ActiveX then you would set the Group property to be the same for all three.
Frankly I think using this many controls is a error-prone to create and maintain, even though it's kind of cool for the user.
Here is an example where you just click directly on the cell itself. I did it down to row 39. The corresponding code is in the sheet module.
O.M.G. not another case of merged cells.!!!!!!!!!!!!
Not helpful and not related to the question.Originally Posted by torachan
Always look at a total project and anticipate the potential for problems.
Pointless solving problems one by one only to be met by the insurmountable further down the line.
Do you have advice specific to this question that will help solve it?
Thanks for the assistance. I will use your suggestions because this was a form being used and based on numerous issues they wanted improvement. The main problem was the check boxes.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks