Wait for Cell

(This action is available in Enterprise Edition only)

Waits for one or more cell until meet the specified criterial. The action is useful when you'd like to monitor some cells in a Microsoft Excel document.

Parameters

• Document name Specifies the document which should be monitored.

• Cells Specifies the cells to be monitored.

Notes

• The document must be opened by the instruction "Open Document" or "Create a Microsoft Excel Document" , or be connected by the instruction "Connect an Open Document" before this step.
• About the timeout, please click here.
• Microsoft Excel program must be present in the computer before playing a macro which contains this action.

• Introduction
• Editions Comparison
• Minimum Requirements
• Uninstalling
• Using Macro Expert
  • Getting Started
    • Basic Concept
    • Creating a New Macro
    • Playing a Macro Manually
    • Recording & Editing Temporary Macro
    • Playing Temporary Macro
    • Stopping Macro Service
    • Scheduling a Macro
    • Triggering a Macro
    • Disabling All Triggers of Macro
  • Macro Manager
    • Macro Manager
    • Working with Progress Window
    • Macro Player Manager
  • Options
    • General
    • Recording
    • Temporary Macro
    • Default Playback Options
    • Hotkeys
    • Macro List
    • Auto-logon
    • Mail Server
    • Proxy Server
    • Appearance
  • Script Editor
    • Looking at Script Editor
    • Editing a macro
    • Working with the variables
    • Attachments
    • Debugging a macro
    • Options
      • General
      • Hotkeys
      • View
      • Debugging
      • Internal Browser
• Macro Properties
  • General
  • Parameters for Playback
  • Triggers
    • Triggers
    • Overview of Trigger
    • Idle Trigger
    • Startup Trigger
    • System Trigger
    • Resource Trigger
    • Driver Trigger
    • Dial Trigger
    • File Trigger
    • Window Trigger
    • Hotkey
  • Schedulers
    • Schedulers
    • Overview of Scheduler
    • Scheduling a Macro
  • Advanced Options
• Internal (built-in) Functions
  • Internal (built-in) functions
  • General & Logical Functions
  • String Functions
  • Mathematical Functions
  • Date and Time Functions
  • Window Functions
  • File Functions
• Macro Commands
  • General Settings and Error Handling Options
  • Keyboard and Mouse
    • Key Action
    • Mouse Action
    • Put a Text
    • Mouse Move Activity
    • Mouse Action on Object
    • Series Keystrokes
    • Change Options of Mouse Actions
    • Change Options of Mouse Actions
  • Dialog
    • Display Message Dialog
    • Select a Folder
    • File-selection Dialog
    • Input Dialog
    • Advanced Input Dialog
    • Show Tip Text
    • Hide Tip text
    • Choice Dialog
  • Window
    • Window Action
    • Keep Window's State
    • Show or Hide Windows on Desktop
  • Wait
    • Delay
    • Wait for Mouse Pointer
    • Wait for Window
    • Wait for Color
    • Wait for UI Object
    • Wait for Keystroke
    • Wait for Mouse Action
    • Wait for Image
    • Wait for File
    • Wait for Process
    • Wait for Expression
  • Play Control
    • On Error
    • Pause
    • Stop
    • End
    • Play Speed
    • Play a Macro
    • Set Emulation Level
    • Block/unblock Mouse and Keyboard
    • Log a Playback Message
    • Redirect Play Log
    • Save Cursor Position for Restoring
    • Reset Keyboard
    • Control Running Macros
    • Set Monitor Window
    • Change Text On Monitor Window
    • Redirect Keyboard/Mouse Actions
  • Custom Functions
    • Add a Function
    • Call Function
    • Exit Function
    • Import Functions Library
  • Variable
    • Set Variable Value
    • Increase/Decrease Value
    • Advanced Set Variable Value
    • Advanced Get Variable Value
    • Swap Two Variables
    • Redefine Variable
    • Fill Array
    • Add an Element to Array
    • Delete an Element From Array
    • Sort all Elements in Array
    • Clone an Array
    • Search for Element in Array
  • Text
    • Find Text
    • Replace Text
    • Convert Text
    • Split Text
    • Pad Text
    • Get Sub Text
    • Extract Text
    • Trim Text
    • Get Text Length
    • Append Text
    • Fomat Datetime
    • Generate Random Text
  • Flow
    • Comments
    • Separator line
    • Label
    • Goto
    • If Expression
    • If Variable
    • If Color
    • If File Exists
    • If Window Exists
    • If Image
    • If UI Object
    • If Webpage Element
    • Select Case
  • Loop
    • Loop
    • Loop Array
    • Loop Windows
    • Loop Files
    • Loop Processes
    • Loop Text
    • Loop Microsoft Excel
    • Loop Dataset
    • Loop Elements of Webpage
    • Exit/Continue Loop
  • System
    • Run
    • Print a Document
    • Image Search
    • Text Search Based on Image
    • Capture Screenshot
    • Read/Write INI File
    • Read Property of Object
    • Read Object's Property From Point
    • Generate Random Number
    • Carry out Action on Object
    • End Process
    • Get Pixel
    • Get Caret (Text Cursor) Position
    • Set System Date and Time
    • Registry Operation
    • Call an External DLL
    • Send Message to Window
  • Session
    • Log off
    • Start Screen-Saver
    • Lock Workstation
    • Shut-down Computer
    • Turn Off/On Display
  • Clipboard
    • Copy, Cut, Paste and Clear
    • Put Data to Clipboard
    • Get Data From Clipboard
  • Multimedia
    • Play an Audio
    • Increase/Decrease Volume
    • Adjust Volume
    • Sound Switch
    • Sound On/Off
    • CD Player
  • Webpage
    • Open a Web page
    • Connect a Opened Webpage
    • Read Field
    • Fill Field
    • Save Image Element
    • Click Element
    • On Popup Window on Webpage
    • Submit Form
    • Find Element
    • Wait for Element
    • Close Webpage
    • Save Webpage Content
    • Save Webpage Cookies
    • Internet Explorer Navigation Actions
    • Change Window of Webpage
  • Network
    • Make Remote Access Connection
    • Disconnect Remote Access Connection
    • Connect Network Resource
    • Disonnect Network Resource
  • Internet
    • Send Email
    • HTTP Download
    • HTTP Post
    • HTTP Get
    • Ping
    • Retrieve Internet Time
    • Delete Tempoary Internet Files
    • Delete Internet Explorer Cookies
    • Clear Internet Explorer History
  • FTP
    • Log On
    • Connect Session in Parent
    • Log Off/Disconnect
    • Download
    • Upload
    • Create Folder
    • Delete Folder
    • Get Current Path
    • Change Current Path
    • Delete Files
    • List Files
    • Rename
    • Move Files
    • Move Folder
    • FTP Command
  • File
    • Copy Files
    • Move Files
    • Delete Files
    • Create a Folder
    • Delete a Folder
    • Rename Files
    • Set File Attributes
    • Change File Time
    • Synchronize Folders
    • Compress Files
    • Extract a Zipped File
    • Read Text File
    • Write Text File
    • Load Binary File
    • Find/Replace in File
    • Get File Attributes
  • Microsoft Excel Document
    • Open Document
    • Create a Microsoft Excel Document
    • Connect Open Document
    • Close Document
    • Save Document
    • Run Macro in Document
    • Read a Cell
    • Read Multiple Cells
    • Write Cell
    • Insert Excel Cells
    • Delete Excel Cells
    • Find Cell
    • Change Color of Cell
    • Add Worksheet
    • Delete Worksheet
    • Activate Worksheet
    • Wait for Cell
  • Database
    • Connect to Data Source
    • Close Data Source Connection
    • Execute SQL Statement
    • Connect Dataset in Parent
    • Close Dataset
    • Set Field Value
    • Get Field Value
    • Get Multi-fields' Value
    • Change Current Record Position
    • Transaction on Data Source
• Variables and Expressions
  • Overview
  • Variables and Arrays
  • Data Types
  • Expressions
  • Operators
• Command Line Usage
• Frequent Question and Answer
• Purchasing Macro Expert