---

Hi NG

I hope that some can help me.


I'm building a userform in Excel where I have to get data from several
textboxes into a variable called SPEED.
Nw my problem is that I can not get Textbox statment changing, if I instad
of "f = TextBox & j & i" writes "f = TextBox12" it works but I only get the
value of one TextBox. What can I do to get all the values from the userform.


Dim SPEED(10, 25) As Double
Dim f As String
Dim i As Integer
Dim j As Integer


i = 1
j= 1

Do
Do
f = TextBox & j & i
SPEED(j, i) = f
i = i + 1
Loop Until i = 25
j=j+1
Loop Until ((j =10) Or (f=""))


Best,
Casper

---

Since you said userform

f = useform1.Controls("TextBox" & j & i).Text


Regards,
Tom Ogilvy


fd <dfg@dfs.dfh> wrote in message news:ag4vda$3sf$1@news.cybercity.dk...
> Hi NG
>
> I hope that some can help me.
>
>
> I'm building a userform in Excel where I have to get data from several
> textboxes into a variable called SPEED.
> Nw my problem is that I can not get Textbox statment changing, if I instad
> of "f = TextBox & j & i" writes "f = TextBox12" it works but I only get
the
> value of one TextBox. What can I do to get all the values from the
userform.
>
>
> Dim SPEED(10, 25) As Double
> Dim f As String
> Dim i As Integer
> Dim j As Integer
>
>
> i = 1
> j= 1
>
> Do
> Do
> f = TextBox & j & i
> SPEED(j, i) = f
> i = i + 1
> Loop Until i = 25
> j=j+1
> Loop Until ((j =10) Or (f=""))
>
>
> Best,
> Casper
>
>