As an alternative to using Visual Studio, FCell has 3 built-in code editors: F#, C# and VB.NET.

Similar to using Excel VBA editor, you define your UDFs and ribbons directly in Excel and the source code is saved in the workbook.

FSharp Udf In Cell

You compile your code with Build button and the customization is immediately loaded into Excel: ribbons and task panes will become visible and UDFs can be used in workbook cells.

You can repeat the process multiple times, on each Build FCell will automatically unload previous customization and load the new one.

The code editor has its own menu:

  • File allows you to compile and save the editor source code into a dll.

  • Edit allows you to comment and indent text in the editor. Completion List is a very useful function which shows a list of potential code completions, e.g. all classes which start with Dat

    Completion List
  • Run is only enabled in F# and allows you to run code in F# Interactive mode.

  • F# can reload F# Interactive references or specify F# editor mode. F# editor can be in Compiled or Interactive mode.

    You use #if to divide your F# code into sections:

    COMPILED section will be compiled on Build and loaded into Excel as customization. The other section defines a script for F# interactive.

    If Interactive