Tuesday, May 3, 2016

Excel Macro - 1

Calling Multiple Macros at  a time:

Call all macros in another macro writing in which order you want to execute.

Sub RunAll()
    Call Macro1
    Call Macro2
    Call Macro3
End Sub


When you want to replace the text after a click of a button, first create the test data in sheet2 and replace in sheet1 by clicking the button. Here assign the macro for each button in sheet1 with different set of test data available in sheet2.


Sub Replacetext()
    ActiveWorkbook.Sheets("Sheet1").Activate
    Sheets("Sheet2").Select
    Range("B3:E9").Select
    Selection.Copy
    Sheets("Sheet1").Select
    Range("B3:E9").Select
    ActiveSheet.Paste
  End Sub
For more information, you can refer to below link: http://www.excel-easy.com/vba.html

Thursday, February 25, 2016

What is Accessibility Testing? Can we do it ? YES

In my current project, accessibility is one of the requirement. As a tester I should make sure that my application is built to access by everone.

I have got some KT from my office collegues and also I googled for some info on it, I got the below link.

Its good and usefull.

http://www.karlgroves.com/2013/09/05/the-6-simplest-web-accessibility-tests-anyone-can-do/

Apart from the given content in the above url, we should also do voice over testing. It means, blind person should able to here the content on the page.

For this we can use Google Chrome extensions i.e chromevox.  ( Search in Chrome extensions in settings tab)