https://docs.lime-crm.com/ Thu, 23 Apr 2026 02:00:44 +0000 FeedCreator 1.8 https://docs.lime-crm.com/ttps://docs.lime-crm.com/lib/tpl/bootstrap3/images/favicon.ico https://docs.lime-crm.com/ https://docs.lime-crm.com/customization/vba/browser?rev=1543788557&do=diff Browser Using a browser can be a good way to show records in a new window instead of showing them in the main explorers in Lime. This example opens a new browser for companies with a vba created filter as active. You can either choose to allow all filters for the class or specify a filter to use in the browser. anonymous@undisclosed.example.com (Anonymous) customization:vba Sun, 02 Dec 2018 22:09:17 +0000 https://docs.lime-crm.com/customization/vba/datahandling?rev=1543788557&do=diff Commmon Lime Classes * LDE.Record - * LDE.Filter - * LDE.Field - * LDE.View - * Lime.Inspector - * Lime.Explorer - * Lime.Control - Records A record is a line in the database of a specific class. 'Open a record Record.Open(Class as class,ID as long,View as view) 'Get options from a field Database.Classes("business").Fields("businesstatus").Options.Lookup("agreement",lkLookupOptionByKey).Value anonymous@undisclosed.example.com (Anonymous) customization:vba Sun, 02 Dec 2018 22:09:17 +0000 https://docs.lime-crm.com/customization/vba/dialogs?rev=1599491752&do=diff Built-in dialogs Lime CRM comes with a number of built-in dialogs that can be used for solving common tasks when customzing the application. Showing a dialog typically involves code along the following lines: Dim Dlg As New Lime.Dialog Dlg.Property("SomeSpecificProperty") = "DialogSpecificConfiguration" If Dlg.Show(DialogType) = vbOK Then ' User confirmed, continue with whatever End If anonymous@undisclosed.example.com (Anonymous) customization:vba Mon, 07 Sep 2020 15:15:52 +0000 https://docs.lime-crm.com/customization/vba/errorhandling?rev=1543788557&do=diff Error handling Cathing errors In all subs and function you should use a error handler. This error handler catches errors and allow you to show the error and stops the Vba from breaking down. Code example Private Sub GetValue() On Error GoTo ErrorHandler 'Write your code Exit Sub ErrorHandler: Call UI.ShowError(“Actionpad_Company.GetValue”) End Sub anonymous@undisclosed.example.com (Anonymous) customization:vba Sun, 02 Dec 2018 22:09:17 +0000 https://docs.lime-crm.com/customization/vba/progress?rev=1543788557&do=diff Indicating progress When doing a heavy job with VBA in Lime CRM, for example creating/updating many records at the same time, it could be a good idea to show the progress to the user. In the examples we create 1000 companies in smaller batches and shows the progress. Here's a few examples of how: anonymous@undisclosed.example.com (Anonymous) customization:vba Sun, 02 Dec 2018 22:09:17 +0000