Key Strokes for Tick Box and Combo Drop Down
Can an expert advise if there are keystrokes when being in a form for:
1) placing a tick in a tick box and reversing it
2) when you tab into a combo field to drop the selection box down
If there are no keys strokes for this, can you give me the vba to asign to the controls.
Many thanks
1) placing a tick in a tick box and reversing it
2) when you tab into a combo field to drop the selection box down
If there are no keys strokes for this, can you give me the vba to asign to the controls.
Many thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Or do you mean that I need the vba as well as the key strokes to make it work?
Peter ...
EMCIT suggestion is correct and the way I would handle that portion of your question.
He is saying, for the Got Focus Event of your drop down box enter ...
Me.YourComBoxName.Dropdown
ET
EMCIT suggestion is correct and the way I would handle that portion of your question.
He is saying, for the Got Focus Event of your drop down box enter ...
Me.YourComBoxName.Dropdown
ET
I think what you're asking is summed up this way
In the Got Focus Event: Me!ComboBoxName.Dropdown
This makes the combo box dropdown as soon as it is reached, like a web based drop down does. Instead of having to hit that little down arrow on the combo box to make the list part drop down.
once it's set up that way then you can do your keystroke thing.
tab tab tab (found dropdownbox) arrowdown arrowdown arrowdown (found item I want) enterkey
J
In the Got Focus Event: Me!ComboBoxName.Dropdown
This makes the combo box dropdown as soon as it is reached, like a web based drop down does. Instead of having to hit that little down arrow on the combo box to make the list part drop down.
once it's set up that way then you can do your keystroke thing.
tab tab tab (found dropdownbox) arrowdown arrowdown arrowdown (found item I want) enterkey
J
ASKER
Thanks for that...very useful even though no straight key stroke for combo box dropdown (unless using vba).
ASKER
Have since learnt that the key stroke for dropping down a combo box on entry is F4
Peter ...
Sorry, I mis-read your question after I reviewed the other comments. I actually thought you were looking for the VBA code to automatically drop down your combo box.
ET
Sorry, I mis-read your question after I reviewed the other comments. I actually thought you were looking for the VBA code to automatically drop down your combo box.
ET
ASKER