How to turn Automatic Completion on/off in Excel 2007

[DocAElstein]

Hello jarhtmd

Code Tags:
If you want to post a code in a Forum such as excelfox, then it is usual to use code tags.

That means that if this is your code:

Sub
‘ Anyfink
End Sub

Then instead of posting that, you post this

[code]
Sub
‘ Anyfink
End Sub
[/code]


If you do that, then in the final posted post, you will actually see the code inside a code window like this

Sub
‘ Anyfink
End Sub

The code tags tell the forum software to put your code in a code window.
The advantage of the code window is that all indent formatting is preserved, and you get scroll bars similar to what you have in the VB Editor code window.

If you want to practice doing that sort of thing, then you should start a Thread here
http://www.excelfox.com/forum/forumd...p/17-Test-Area
Give the thread a title such as “Just Testing Posting techniques. No Reply needed”

_.________________

Excel Options

This is how I get that for Excel 2007

_1 Click the Microsoft Office Button,
_2 Click Excel Options
XL2007MicrosoftButton_1Options_2.JPG https://imgur.com/2kY2rVx
XL2007MicrosoftButton_1Options_2.JPG

This is how I get that for Excel 2010
_1 Click Home Tab
_2 Click Excel Options
XL2010Home_1Options_2.JPG https://imgur.com/uyauCRP
XL2010Home_1Options_2.JPG

_.________________________________

This is a simple code I often use to “turn everything on”.
I am not too familiar with what auto complete actually means. I am not sure if that is “turned on” with Application.Calculation = xlCalculationAutomatic.

Sub Oops()
 Let Application.ScreenUpdating = True
 Let Application.Calculation = xlCalculationAutomatic
 Let Application.EnableEvents = True
 Let Application.DisplayAlerts = True
End Sub

If you need help on how to run that code then let me know


Alan