Do the following in your VBA editor window (entitled &quot;Microsoft Visual Basic for Applications&quot;):

Click the menu &quot;**Tools**&quot; and then &quot;**Options**&quot;.

In the Options&#39; &quot;Editor&quot; tab, uncheck the &quot;**Auto Syntax Check**&quot; 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 &quot;Editor Format&quot;).

MS Office programs share this common VBA editor, so if you change an option while editing VBA for Excel then you&#39;ve changed it for Outlook, Word, etc.

![MS VBA editor&#39;s Tools Options dialog box][1]

  [1]: http://i.stack.imgur.com/iDbxy.jpg

In the VBE, Tools - Options - Editor and uncheck Auto Syntax Check.  It will turn bad code red, but won&#39;t give you the popup.

I&#39;d like to compare two css files which are not in any git repository. Is there such a functionality in git?

How to compare two files not in repo using git

How do you get Jenkins to execute python unittest cases?
Is it possible to JUnit style XML output from the builtin `unittest` package?

Python unittests in Jenkins?

When you&#39;re editing a Microsoft Office VBA macro or function, you will often move your cursor from a line that you haven&#39;t finished.  For example, to go copy something you want to paste into that line.  But, if that partial line isn&#39;t syntactically valid, the VBA editor interrupts your work by popping up a &quot;Compile error&quot; 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.)

When editing Microsoft Office VBA, how can I disable the popup &quot;Compile error&quot; messages?

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.)

    Sub test()
    
    thesentence = InputBox(&quot;Type the filename with full extension&quot;, &quot;Raw Data File&quot;)
    
    Range(&quot;A1&quot;).Value = thesentence
    
    If Dir(&quot;thesentence&quot;) &lt;&gt; &quot;&quot; Then
        MsgBox &quot;File exists.&quot;
    Else
        MsgBox &quot;File doesn&#39;t exist.&quot;
    End If
    
    End Sub


In this when i pickup the text value from the input box, it doesn&#39;t work. If however, if remove ``&quot;the sentence&quot;`` from If ``Dir()`` and replace it with an actual name in the code, it works. Can somebody help?

Check if the file exists using VBA

How do I convert the **integer** value &quot;45&quot; into the **string** value &quot;45&quot; in Excel VBA?

How Do I Convert an Integer to a String in Excel VBA?

The problem is that `!=` does not work as a function in excel vba.

I want to be able to use 

`If strTest != &quot;&quot; Then` instead of `If strTest = &quot;&quot; Then`

Is there another approach to do this besides `!=`?


My function to mimic `!=` is 


    Sub test()
    
    Dim intTest As Integer
    Dim strTest As String
    
    intTest = 5
    
    strTest = CStr(intTest) &#39; convert
    
    Range(&quot;A&quot; + strTest) = &quot;5&quot;
    
    
    
        For i = 1 To 10
            Cells(i, 1) = i
            
            If strTest = &quot;&quot; Then
                Cells(i, 1) = i
            End If
    
        Next i
    
    
    End Sub







What is the equivalent of &quot;!=&quot; in Excel VBA?

I&#39;ve found this method for finding the last data containing row in a sheet:

    ws.Range(&quot;A65536&quot;).End(xlUp).row

Is there a similar method for finding the last data containing column in a sheet?

How do I find the last column with data?

We are writing an MS Outlook plugin. To satisfy our business-logic, it should check all appointments between some dates. We are experiencing several problems with retrieving all items from calendars. We tried two options:

1. Outlook API. We use the standard logic that is described in MSDN - sort items by [Start], set `IncludeRecurrences` to `True` and run the Find\Restrict query over calendar items [like here](http://msdn.microsoft.com/en-us/library/office/aa220093(v=office.11).aspx). It works fine in our test environment. However, in our customer&#39;s environment: For recurring appointments, start and end dates are set to the corresponding dates of a &#39;master appointment.&#39; For example, in some room&#39;s calendar we have a weekly appointment that was created in January, and if we try to find all items in August, we get among others four items of this recurring appointment, but their start and end dates are set to January. But Outlook displays correct dates in the same calendar...

2. Very bad, but we still have WebDAV! We write a simple test application and try to query all items from the calendar using WebDAV. Of course, we didn&#39;t reinvent the wheel and just pasted the code from [documentation](http://msdn.microsoft.com/en-us/library/exchange/aa123570(v=exchg.65).aspx). The previous problem is solved, but the next one arises: It doesn&#39;t return recurring items that were created more than approximately six months ago. I Haven&#39;t a clue - there are no parameters restricting &#39;old&#39; items! 

What is wrong? Are we missing something important? 

Technical details: Exchange 2003, Outlook 2003-2010. Frankly speaking, the first error disappears if we turn on Cached Exchange Mode, but we can&#39;t do that.

&lt;!-- language: c# --&gt;

    var nameSpace = application.GetNamespace(&quot;MAPI&quot;);
    var recepient = nameSpace.CreateRecipient(roomEMail);
    recepient.Resolve();
    var calendar = nameSpace.GetSharedDefaultFolder(recepient, OlDefaultFolders.olFolderCalendar);
    var filter = string.Format(&quot;[Start]&lt;&#39;{1}&#39; AND [End]&gt;&#39;{0}&#39;&quot;,
      dateFrom.ToString(&quot;dd/MM/yyyy HH:mm&quot;, CultureInfo.InvariantCulture), dateTo.ToString(&quot;dd/MM/yyyy HH:mm&quot;, CultureInfo.InvariantCulture)
    );
    var allItems = calendar.Items;
    allItems.Sort(&quot;[Start]&quot;);
    allItems.IncludeRecurrences = true;
    var _item = allItems.Find(filter);
    while (_item != null) {
      AppointmentItem item = _item as AppointmentItem;
      if (item != null) {
        if (item.Subject != &quot;some const&quot;)
          &amp;&amp; (item.ResponseStatus != OlResponseStatus.olResponseDeclined)
          &amp;&amp; (item.MeetingStatus != OlMeetingStatus.olMeetingReceivedAndCanceled 
          &amp;&amp; item.MeetingStatus != OlMeetingStatus.olMeetingCanceled))
        {
          /* Here we copy item to our internal class.
           * We need: Subject, Start, End, Organizer, Recipients, MeetingStatus,
           * AllDayEvent, IsRecurring, RecurrentState, ResponseStatus,
           * GlobalAppointmentID */
        }
      }
      _item = allItems.FindNext();
    }

##UPDATE 1:
Additional research using OutlookSpy shows that the problem is not in our code - the Start\End dates are incorrect inside the API when Cached Exchange Mode is off. But Outlook developers were aware of it, and they somehow display correct dates in calendars! Does anyone know how?

### UPDATE 2: 
Answer from Outlook Support Escalation Engineer: 
&gt; Based on this, I can confirm that this is a problem in our product.

Retrieve calendar items (Outlook API, WebDAV) displaying strange behaviour

Is there any shortcut for maximizing the tab you are working on in Eclipse? Assume I am working on part of a code and I want to maximize the tab not using the double click on it with the mouse, does anyone know a way? 

Maximize code tab in eclipse shortcut

I watched a video from YUIConf 2012 in which Douglas Crockford gives a talk about implementing monads in JavaScript. In this talk he gives a code example that utilizes what he calls &quot;Context Coloring&quot; which throws out the idea of coloring by language syntax and introduces different colors for different levels of scope. Here is the link to that specific part of the video.

http://www.youtube.com/watch?feature=player_embedded&amp;v=dkZFtimgAcM#t=15m58s

**Is this context coloring scheme implemented by any code editor for JavaScript or any language?**

I use Sublime Text and this editor like every other code editor I have come across allows color to be applied to syntax. Im not sure if a plugin could solve this problem or if an editor would have to be designed from the ground up to allow this context coloring scheme.



Is Crockford style Context Coloring implemented in any code editor?

Lots of friends have suggested me to start using Sublime Text instead of Notepad++, but I&#39;ve been happy so far with Notepad++. I use Notepad++ mainly for quick editing files (Haskell, Python, C#, HTML, JS, CSS, etc.), copying &amp; paste pieces of text and running macros on it, etc.

What are the main differences in the feature set of Sublime Text and Notepad++?

What are the advantages of Sublime Text over Notepad++ and vice-versa?

I am developing with meteor and Webstorm, being that meteor automatically updates the browser and Webstorm saves after you stop typing. It gets annoying. I checked my preferences and I can see that I have &#39;save automatically&#39; unchecked. How do I completely stop the auto save feature in web storm ?

How to Turn off automatic saving on web storm

I did try searching for this, but honestly the terms to actually search are escaping me. A small code snippet followed by the question. 

    Public class Person {
    
       String firstName;
       String lastName;
    
       public void setFirstName(String firstName) {
          this.firstName = firstName;
       }
    
       public String getFirstName() {
          return firstName;
       }
       ...
    }

In **another object that uses this person object** I would like to be able to expand all the setters methods in Intellij.   

    public class PersonAssembler { 
        public static Person assemblePerson(SomeOtherObject someOtherObject) {
       
        Person person = new Person;
        
        //intellj would provide this below.
        person.setFirstName();
        person.setLastName();
        //end of what intellj provides.

        return person;
    }

Is this even possible?  I have looked through the keyboard short cuts, etc.  I have been using intellij for a while, so just wondered if anyone had some insight on this.  

I was hoping for column edit mode, then code completion and perhaps a shift+down arrow to select multiple completions, but no luck.  Which is not surprising.  I would hate to have to write that in the GUI.

Edit:  I added some clarification and honestly forgot about this question.  The answers have nothing to do with the actual question if read carefully.  I am not speaking of the Generate context menu.

Content Type	Original Author	Original Content on Stackoverflow
Question	Iain S	View Question on Stackoverflow
Solution 1 - Vba	ray	View Answer on Stackoverflow
Solution 2 - Vba	Dick Kusleika	View Answer on Stackoverflow

When editing Microsoft Office VBA, how can I disable the popup "Compile error" messages?

Vba Problem Overview

Vba Solutions

Solution 1 - Vba

Solution 2 - Vba

Python unittests in Jenkins?

How to compare two files not in repo using git

Attributions