Display drop list when sell is clicked

I have the following code so after i select a cell the zoom changes so i can see better the results.

Now i need to automatically display the validation and after value in that cell changes adjusts the zoom value.

The code i have, detects if the cell has validation list in it, increases the zoom and if i click in a cell that has no validation, it reduces the zoom.

Please Login or Register  to view this content.

Any solution to open the droplist on cell selection ?

Hi there,

See if the following code does what you need:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

Mr. Greg if you need more information let me know, i would like to put this working asap

Hi again,

I think I understand what you mean, but I don't know how to implement it - sorry.

Regards,

Greg M

Originally Posted by Greg M

Hi again,

I think I understand what you mean, but I don't know how to implement it - sorry.

Regards,

Greg M

Ok thank you