IntroductionContact UsCopyrightOn-line Help LibraryWhich file formats are supportedComparison StrategyxlCompare CommandsFile | OpenFile | Recent ComparisonsCompare | BooksCompare | SheetsCompare | ModulesCompare | OptionsView | LayoutView | Ignore FormattingTools | RecalculatexlCompare ActivationHow to activate xlCompare on the another PC?How to restore xlCompare on my PC?License detailsHow to remove trial limits?General Questions Extended View modeDisplay differences in Extended ViewFilter differencesMerge data from two worksheetsUpdate records on the worksheetDuplicate RemoverGet duplicates between 2 listsExtract Unique RecordsCommand Line modeSave changes in the workbookSave comparison report on diskWorking with TXT and CSV filesFilter data you want to compareIgnore error valuesTrace Formula CalculationsMinimize Difference BrowserSynchronize rows and columnsMark differences (changed cells) with colorDatabase ComparisonCompare worksheets As DatabaseManage Primary KeysHide Equal ModulesFilter cells on the worksheetJoin 2 lists in ExcelFind duplicates in ExcelRemove duplicates in ExcelRemove empty rows on the worksheetBulk Merge operationsBulk Undo operationHighlight only results you needVersion ControlUse xlCompare with SVN to resolve conflictsCompare Visual Basic ProjectsCompare controls on the VB FormsMerge controls on the formsMerge contents of the VBA ModulesI've found a problemSending bugreports to Spreadsheet Tools

How to compare controls on the forms?

xlCompare is a unique Excel Workbook Comparison software which allows to edit and merge VB Forms.
To switch to the Form Editor, use View | Form Objects ribbon command:
Visual Basic Form editor
To switch between Form objects use Tab Strip on the bottom. Like you are chaning worksheets. xlCompare uses same interface to display all types of the spreadsheet objects. This makes the software easy to use.
This window displays:
  • Visual representation of all controls on the form
  • All controls on form combined into hierarchical tree. You can see all control you have on the form, including hidden onces
  • List of the properties for each control
The Compare operation produces results like this:
Visual Basic Form - Difference Explorer
All differences, found by xlCompare, are reflected in the Difference Explorer window.
Differences higlighted on the Visual Basic Form
New, Deleted and Changed controls are highlighted with color in the editor window.
xlCompare gives you complete information about changes on the VB Forms!