I want to automate the formatting within Excel. How do I capture right click menu and select an item from there, such as “Format Cell”?
You can change ‘MouseButton’ property of Click Activity to ‘BTN_RIGHT’ to perform right click.
To select the Value from the Popup list,
- Use ‘Indicate on Screen’
- Navigate to the excel sheet,
- Press F2 (this will give you 3 seconds of wait time for selection),
- Right click within that 3 seconds,
- Move your cursor to the value of the popup and wait for the wait time to get over,
- Once over select that value form the popup.
Hope it helps.
Thank you! This did it. @Rammohan91