Home » Forums » Open Source Learning Center » Question and Answer

Run Macro Once select/deselect a cell

Submitted by Sandrahan on 18 February, 2012 - 11:42

Dear experts,
I made a small macro to change the input language from English to another one "Once select a specific cell"
And also it re-activate the English when deselect this cell
--
Actually I need your support to make this happen when I select any cell in a specific “row”
So, once a cell from that row selected a Macro should start to change the language then the English will back again when I select any cell out of this row

Note: I attached a file for more details
http://www.mediafire.com/?ksjzy1a3il5pmdj

Thanks many in advance

‹ How to auto copy rows based on date AutoFilter-Copy Paste-Save sheet-Delete info ›
»
Vishesh's picture

Change selectionchange event

Submitted by Vishesh on 18 February, 2012 - 14:41.

Change selectionchange event to

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)

    Select Case Target.Row

    Case 5, 8

        Call ActivateKeyboardLayout(lang_Hendi, KLF_REORDER)

    Case 6, 9

        Call ActivateKeyboardLayout(lang_Hebrew, KLF_REORDER)

    Case Else

        Call ActivateKeyboardLayout(lang_English, KLF_REORDER)

    End Select

End Sub

 
»

It's work

Submitted by Sandrahan on 18 February, 2012 - 18:06.

work perfectly

Thanks again.

»