Posted 8 September 2017, 2:02 pm ESThowv to show the current cell value in textboxt by using vb2008?
Posted by: redahashem-fp on 8 September 2017, 2:02 pm EST
Replied 8 September 2017, 2:02 pm EST
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
I hope it will help you.
Replied 8 September 2017, 2:02 pm ESTthank you so much it works great