Z4Soft Contact us
 
 

PTab Spreadsheet Macro Samples

Simple Samples

Name Description Demonstrated  features/functions
ListBox Various methods how to create tappable in-cell listbox Tap on cell, Listbox(), Listbox2()
Button Button sample Tap on cell, Zoom()
CheckBox Checkbox Tap on cell, Set(), ActiveCell()
OnFileOpen OnFileOpen macro OnFileOpen, MsgBox()
Sort Sort of table by tapping on a column heading Tap on cell, Sort(), Sel()
Conditional Formatting Format a cell according to its value New Value In, FormatPainter()
Custom View Show/hide part of table New Value In, Data Validation, ColHide(), RangeRef()

 

Advanced Samples

MathActionOnRange Performs math operation (+,-,*,/) on a range of cells Menu Item, for cycle, InputBox(), CellRef(), ListBox2()
TrackChanges Creates journal of cell changes New Value In, ActiveSheet(), LastRow(), Now(), Address()
PriceRules Shows how to use macros to implement business rules New Value In, macro subroutines, Weekday()
Calendar Day calendar New Value In, Tap on cell, macro subroutines, OnFileOpen, FormatPainter(), DateValue(),
Alcohol Calculates and creates chart of alcohol blood level CellTask(), ListBox2(), Copy()
Linear Equations Linear equations solver Tap on cell, LastRow(), LastCol(), CellRef(), RangeRef()
Database Database form New Value In, Tap on cell, macro subroutines, DeleteCells(), FormatPainter(), TopLeftCell(), ActiveSheet()
DetInv Calculates determinant and inverse matrix Tap on cell, Copy(), Paste(), RangeRef(), LastRow()
Functions Creates charts of sin x, cos x, etc. functions Cell task, ListBox(), RangeRef()
PTabInvoice Fully functional invoice manager. Enable creation, editing, printing (on desktop/hpc), invoices, products, customers. New Value In, Tap on cell, DeleteCells(), ListBox(), Clear(), YesNoBox()

 

 

 

Copyright 2017 Z4Soft. All rights reserved.