ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,224
- Office Version
- 2007
- Platform
- Windows
Hi,
As per title i wish to get worksheet cell value to userform textbox.
The code below is in use.
I get no RTE but textboxes remain blanl.
Some info for you.
Worksheet is called HONDA SHEET
Values are in cells Z21:Z57
Userform Textboxes are Textbox 1 through to Textbox39
As per title i wish to get worksheet cell value to userform textbox.
The code below is in use.
I get no RTE but textboxes remain blanl.
Some info for you.
Worksheet is called HONDA SHEET
Values are in cells Z21:Z57
Userform Textboxes are Textbox 1 through to Textbox39
Rich (BB code):
Dim x As Integer
Dim ws As Worksheet
Set ws = ThisWorkbook.Sheets("HONDA SHEET")
x = 1
For x = 1 To 39
Controls("TextBox" & x).Value = ws.Range("Z21" & x).Value
Next x