how to fetch data from a table on check event of a checkbox in excel vba

Hi Guys,

I am having issues while running a script which actually checks in a worksheet for the checkboxes set to true. I am trying to run a loop which will get these checkboxes (checked) and store their caption in an array. Then I want to search another worksheet/table with that caption.

The code snippet i tried is mentioned below. This code is just checking for the caption values are getting retrieved or not:

Please Login or Register  to view this content.

All the excel gurus out thr plzz help.

Hello basubdd,

Try this code...

Please Login or Register  to view this content.

Hello basubdd,

Glad you asked that question. You won't find this information in the books. The Forms Checkbox control can be controlled in 3 ways: Manually clicking it, Using a Linked Cell, or by Code. Manually will not be discussed.

The Checkbox control will respond to a Linked Cell when the cell's value is either a Boolean True or False. It would make sense the same would hold true for controlling it by code. But, this is Microsoft we are talking about.

When setting the Forms Checkbox to checked or clear state using code, there are 2 constants used for this purpose: xlOn and xlOff. The values are actually 1 and -4146, respectively. These values are not the same as the VBA Boolean values of -1 and 0. This why your code fails.

Hello basubdd,

That is correct.

Hello basubdd,

It appears another member has been helping you successfully with this post. My help at thsi point would be redundant.