I would like to make an user form that reads multiple data(numbers) - like different configuration of a model - separated by "space" and use that further to make the drawings for each configuration. My problem is that I can write such an user form ,in Visual Basic 2008 for example, but I have problems in VBA.
In VB 2008 it would be like this:
Private Sub CommandButton1_Click()
Dim subStrings() As String = TextBox1.Text.Split(" ")
For Each substring As String In subStrings
MsgBox (CInt(sbstring) & " is goed")
In VB 2008 runs perfect, showing a pop-up window for each inputted value, but when I try to run it in VBA, it highlights ".Text" with the message : Compile error: Invalid qualifier.
Does anyone have an idea?
Thanks in advance...