How to pop a form when clicked on cell

[meprad]

Dear friends,
I have a question on excel 2010. I have a multiple rows (simple) with text and values. what i want is to pop a form that actually has parameters with checkboxes (multiple choice) should open when i click on last cell of the row. This enables to give score - lets say if 3 checkboxes ticked then score is 3 and that will be displayed on that cell. To make you more easy to understand, I attached a snapshot to best describe the requirement.


many thanks for your help
snapshot.PNG
meprad

[:) Sixthsense :)]

The below code will popup the userform when the cursor reaches any of the cell in the range D2:D10

Please Login or Register  to view this content.

Change the name of userform to your userform name, if required.

[meprad]

many thanks Sixthsense for your input, could you pls suggest how do i get value based on number of checkboxes marked in the form...automatically in the range of D2:D10 ...I really appreciate your help in this.

[:) Sixthsense :)]

Please attach a sample workbook with your form for giving exact solution

[meprad]

Please find attached xlsm file. I mentioned my requirement there in the file.

Thank you so much!

[:) Sixthsense :)]

Just replace your form command button code with the below code

Please Login or Register  to view this content.

[meprad]

Ohhh!! you are a super Excel Hero ...this is just what i wanted ...thanks a million for this help ....god bless you my friend. by the way would it be possible to make selection viewable on the form when i click back those forms or there be other way ...just to view which options were selected.....

[:) Sixthsense :)]

Replace this

Please Login or Register  to view this content.

With

Please Login or Register  to view this content.

Thanks for the feedback too...