How to link textbox value to a specific cell value? 1

[gulong]

Hi, I am using VBA in excel and I have difficulties to assign textbox a value from worksheet cells. Can anybody help me out? Thank you very much in advance.

 

[JustinEzequiel]

Dim oSheet As Worksheet
Dim oBook As Workbook
Dim oCell As Range

Set oBook = ActiveWorkbook
Set oSheet = oBook.Worksheets("Sheet1&quot
Set oCell = oSheet.Range("H26&quot

Me.TextBox1.Text = oCell.Text

Set oCell = Nothing
Set oSheet = Nothing
Set oBook = Nothing

 

[Quarlton]

Hi,
I have used a combobox, and I used in the properties of it
ListfillRange: Data!A2:A5 data is my sheet where are stored
my values in the cells a2 => till a5
and if you want it is possible in the Linkedcell set the cell where are stored your resultat ...
I hope it will give you an idea ...