Search
FindReplaceForm Methods
 


 Public Methods

  Name Description

addCellListener

Registers listener so that it will receive events from the form.

getCurrentCell

Gets the cell to start the search from.

getFind

Gets the text to find.

getFindWithin

Gets the target of the search the referenced worksheet or the entire workbook.

getLookIn

Gets whether to search in formatted cell text, unformatted value or formula.

getMatchCase

Gets a value indicating whether the search should be case-sensitive.

getReplace

Gets the text to replace with.

getSearchOrder

Gets the search order - horizontal or vertical.

getWholeCells

Gets a value indicating whether to match entire cells only.

removeCellListener

Unregisters listener so that it will no longer receive form events.

setCurrentCell

Sets the cell to start the search from.

setFind

Sets the text to find.

setFindWithin

Sets the target of the search the referenced worksheet or the entire workbook.

setLookIn

Sets whether to search in formatted cell text, unformatted value or formula.

setMatchCase

Sets a value indicating whether the search should be case-sensitive.

setReplace

Sets the text to replace with.

setSearchOrder

Sets the search order - horizontal or vertical.

setWholeCells

Sets a value indicating whether to match entire cells only.

 See Also