Excel range to a form's textboxes how-to

[Brian.Crawford]

I have a number of separate (named) ranges of Excel columns (annual periods 1-12) that I wish to display on a user form in a series of textboxes, 1-12 across with separate rows for category (budget, actual, etc., each has separate named range). What is the simplest way to make the transfer. I was considering moving the cells to an array for each category and then from an array to the textboxes. But I am not sure if that the best way and even if it is I am not sure of the most efficient or any way to get the data from the array to the textboxes in a simple manner.
Any suggestions please
thanks in advance

 

[tweedle]

Could do something like this in a Form event/button
(Assumes Textboxes are 0-11 for budgeted, 12-24, actual, etc. )

Dim C As Range
CtrlIdx = 0
For Each C In Range("budget")
    'Me.Controls(CtrlIdx).BackColor = RGB(200, 150, 50) 'For Testing
    Me.Controls(CtrlIdx) = C
    CtrlIdx = CtrlIdx + 1
Next
 
CtrlIdx = 12
For Each C In Range("actual")
    'Me.Controls(CtrlIdx).BackColor = RGB(256, 150, 0) 'For Testing
    Me.Controls(CtrlIdx) = C
    CtrlIdx = CtrlIdx + 1
Next

 

[Brian.Crawford]

Thanks, basically that is what I ended up doing. Hoped there might be a simplier way but guess not.