Vba – When editing Microsoft Office VBA, how can I disable the popup “Compile error” messages

editorvba

When you're editing a Microsoft Office VBA macro or function, you will often move your cursor from a line that you haven't finished. For example, to go copy something you want to paste into that line. But, if that partial line isn't syntactically valid, the VBA editor interrupts your work by popping up a "Compile error" message that has to be dismissed.

Is there any way to disable the message box? I find it irritating…

(This happens with Excel Visual Basic for Applications, Outlook VBA, Word VBA, etc.)

Best Answer

Do the following in your VBA editor window (entitled "Microsoft Visual Basic for Applications"):

Click the menu "Tools" and then "Options".

In the Options' "Editor" tab, uncheck the "Auto Syntax Check" box. (See screenshot, below.)

This change does not make the editor stop compiling in the background and marking syntax errors in red (or whatever formatting is specified in the Options tab "Editor Format").

MS Office programs share this common VBA editor, so if you change an option while editing VBA for Excel then you've changed it for Outlook, Word, etc.

MS VBA editor's Tools Options dialog box

Related Solutions

Vba – How to comment and uncomment blocks of code in the Office VBA Editor

In the VBA editor, go to View, Toolbars, Customise... or right click on the tool bar and select Customise...

Under the Commands tab, select the Edit menu on the left.

Then approximately two thirds of the way down there's two icons, Comment Block and Uncomment Block.

Drag and drop these onto your toolbar and then you have easy access to highlight a block of code, and comment it out and uncomment with the click of a button!

See GauravSingh's answer if you want to assign keyboard shortcuts.

Ios – Adding a search bar to the top of a UITableView

Usually you just use UISearchBar as a tableViewHeader for your table view. If you want it hidden when the user enters the screen (like it's done in most native apps) you can just set contentOffset for the tableView in viewWillAppear.
And I am pretty sure that's in fact how they do it. And if you think about it it's what tableHeaderView is meant for.

Try something like this:

- (void)viewDidLoad
{
    [super viewDidLoad];

    UISearchBar *searchBar = [[UISearchBar alloc] initWithFrame:CGRectMake(0., 0., 320., 44.)];
    self.tableView.tableHeaderView = searchBar;
}

- (void)viewWillAppear:(BOOL)animated
{
    [super viewWillAppear:animated];

    CGPoint contentOffset = self.tableView.contentOffset;
    contentOffset.y += CGRectGetHeight(self.tableView.tableHeaderView.frame);
    self.tableView.contentOffset = contentOffset;
}

Note that in iOS 7 you should not just set the contentOffset of your tableView to CGPointMake(0., CGRectGetHeight(self.tableView.tableHeaderView.frame)) if your viewController has automaticallyAdjustsScrollViewInsets set to YES, since it probably will not be CGPointZero in viewWillAppear:

Best Answer

Related Solutions

Vba – How to comment and uncomment blocks of code in the Office VBA Editor

Ios – Adding a search bar to the top of a UITableView

Related Topic