I have code set up such that when a cell with a drop down menu is chosen, the
screen view increases to 120% (so the drop down list is easier to read).
Once the selection in the menu is made, you can click any other cell and the
screen view returns to the original zoom value and a specific cell, A1.
Rather than an extra key stroke of clicking another cell, I would like to to
have the screen view zoom and cursor location all happen when the drop down
menu selection is made. I appreciate any feedback as to how to accomplish
this.

lean cost man,

Is the drop down menu a combo box or is it the validation drop down box?


"lean cost man" wrote:

I have code set up such that when a cell with a drop down menu is chosen, the
screen view increases to 120% (so the drop down list is easier to read).
Once the selection in the menu is made, you can click any other cell and the
screen view returns to the original zoom value and a specific cell, A1.
Rather than an extra key stroke of clicking another cell, I would like to to
have the screen view zoom and cursor location all happen when the drop down
menu selection is made. I appreciate any feedback as to how to accomplish
this.

This is a Combo Box.

"JR Form" wrote:

lean cost man,

Is the drop down menu a combo box or is it the validation drop down box?


"lean cost man" wrote:

I have code set up such that when a cell with a drop down menu is chosen, the
screen view increases to 120% (so the drop down list is easier to read).
Once the selection in the menu is made, you can click any other cell and the
screen view returns to the original zoom value and a specific cell, A1.
Rather than an extra key stroke of clicking another cell, I would like to to
have the screen view zoom and cursor location all happen when the drop down
menu selection is made. I appreciate any feedback as to how to accomplish
this.