How can I accept the suggestions the VBA IDE displays as I type without either double clicking on them or hitting enter? Enter automatically inserts a carriage return, which I usually don't want; and double clicking is slower than typing for me.
Printable View
How can I accept the suggestions the VBA IDE displays as I type without either double clicking on them or hitting enter? Enter automatically inserts a carriage return, which I usually don't want; and double clicking is slower than typing for me.
Use the arrow keys to highlight the property or method you want from the Intellisense popup list. Then press Ctl+Enter to accept
the selection to your line of code and keep the cursor on the same line and right after the last char of the property or method you selected.
The space bar also works for making the selection once its highlighted but places a space after the property or method.
Or tab.
just type any key
the next key you want to use or space at end of line if you don't want newline
pete
Much obliged! Thanks!