Button

Inserts a labeled push button control into the spreadsheet.

Note:
  • To access the Property Sheet for a Button, right-click the button and select Edit Function.
  • A button click generates two events. The state of the button changes from 0 to 1 when pressing the button down, then from 1 to 0 when releasing the button..

Button Inputs

Parameter Description

Name

Specifies a text string or reference to a text string; this name will appear on the button itself.

Button Outputs

Returns

A value of 1 when the button is pressed; otherwise the return value is 0.

Results

A labeled Button control.

Button Example

  1. Assume cells A3 and A4 are configured as follows:

    A3=Button("Test")

    A4=Count(A3,9999999,0,0)

    The spreadsheet looks like this:

  2. Press the button in cell A3. Cell A4 references cell A3 to count the number of times the "Test" button is pressed. The value in cell A4 is now 1.000.