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
Code:
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.
Code:
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
Bookmarks