current cell

Posted by: redahashem-fp on 8 September 2017, 2:02 pm EST

  • Posted 8 September 2017, 2:02 pm EST

    howv to show the current cell value in textboxt by using vb2008?
  • Replied 8 September 2017, 2:02 pm EST

    Hello,

    There are several ways to do that , you may get the ActiveRow and Active Column Index and get the Corresponding text in the TextBox as I did in the following ButtonClick Event.

         Dim str As String
         Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
            str = FpSpread1.ActiveSheet.Cells(FpSpread1.ActiveSheet.ActiveRowIndex, FpSpread1.ActiveSheet.ActiveColumnIndex).Value
            TextBox1.Text = str
         End Sub

    I hope it will help you.

    Thanks,

     

  • Replied 8 September 2017, 2:02 pm EST

    thank you so much it works great
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels