VB.net how to wait for user to select an Excel cell

Question

I have created a VSTO project in Visual Studio with a Ribbon and a Form. There is a button on this form which I want when a user clicks on it, it waits for user to select a single cell from the workbook which this add-in is used in it.

I am currently at designing stage and have not much code written. Any key ideas to achieving this? Should I use Application.SendKeys method? Any other/better ideas?

Thanks

My Ribbon Code so far:

Imports Microsoft.Office.Tools.Ribbon

Public Class Ribbon1

    Private Sub Ribbon1_Load(ByVal sender As System.Object, ByVal e 
    As RibbonUIEventArgs) Handles MyBase.Load

    End Sub

    Private Sub Button1_Click(sender As Object, e As 
        RibbonControlEventArgs) Handles Button1.Click
        Dim f As New Form1
        f.Show()
    End Sub

End Class

My Form Code so far:

Public Class Form1

    'Variables for my "Custom Vlookup Function"
    Dim RHeader As Excel.Range 'Reference Header
    Dim SRange As Excel.Range 'Seleceted Range
    Dim ColNo As Integer 'Column number ahead

    Dim xlApp As Excel.Application = Globals.ThisAddIn.Application
    Dim xlWB As Excel.Workbook = 
    Globals.ThisAddIn.Application.ActiveWorkbook

    Private Sub Button2_Click(sender As Object, e As EventArgs) 
        Handles Button2.Click

    End Sub
End Class

Answer 1

Wait for the Worksheet.SelectionChange event which is fired when the selection changes on a worksheet.