Help in Making a Checkbox macro

[abdullahsikandar]

Hi Guys,

I need your help in making a macro or any trick where i can have list of checkboxes and when i select any checkbox from there so the value or the label or that checkbox automatically added in the cell of excel.

There can be two ways we can do that:

1) we can make a macro where when we click on that cell in excel the "listbox of checkbox" will be open and we can select a bunch of checkboxes and there values will be automtically added into that cell.( is this possible?)?

2) We can make on user forum and when we click on the cell that "User forum" will be open and once we select our checkboxes their values will be added automatically into that cell?

Is it possible? If yes, so, Kindly advice me i am new in in Vb and trying to make this project ... Please help me.

Thank in advance.

[AndyLitch]

TEST.xlsm

That's a userform approach

[abdullahsikandar]

HI Andy,

Thanks for your reply, the file you sent me that`s awsome but there are some more changes in that like, for example:

If user select checkbox1, checkbox2, checkbox4 or i so it will show checkbox1 [space] "," Checkbox2 [space] and checkbox4 in one column.

what i mean to say is that in one row every other cell will open the userform which is happening and after that if i select any combination of checkboxes it will show up in one column.

Thanks in advance

[AndyLitch]

TEST.xlsm

Userform is triggered by selecting any even numbered column
The results are concatenated in column E of the selected row

[abdullahsikandar]

Test_Validations.xlsx

Hi Andy,

Thanks a lot for your help, that`s what we wanted ... I have another question regarding null values... Can you help me in that?

For Example:

there are 5 rows and 5 columns, we have a button which checks for null values with respect to a specific column (here it should check with respect to ID and it shouldn`t leave any null values in the Date, Name, Age and the user should be able to give the null values for the cities.)

So i attached the form in this sheet where i am trying to press the button and check for the validation, Kindly help us in this manner also.

[AndyLitch]

That's against forum rules I'm afraid... You'll have to start a new thread for a separate issue.

[abdullahsikandar]

Thanks Andy,


I started a new thread already, Kindly help me over there .


http://www.excelforum.com/excel-prog...ull-cells.html

[abdullahsikandar]

Test_file_for_buttons.xlsm
Hi Andy,

I am trying to apply the method you told me, But i dont know why where i am lacking and its not showing me the country name i almost did the same code which you did earlier. I am attaching the file kindly let me know where i am lacking in the code so i can do it easily. The columns where i want this form is column Q and V.