How to create a control array of textboxes

[Schwizer]

On this website:

He instructs to make a control array of textboxes on a userform

six text boxes in a control array (Text4(0) - Text4(5)).

but i can't figure out how to do it manually. I can't find the "index" property of the textbox so when i try to make a second textbox with the same name, it gives me an error. Any ideas?

Cheers

[Leith Ross]

Hello Schwizer,

Randy's code is written for Visual Basic (VB). Excel uses Visual Basic for Applications (VBA). VB supports the use of Control Arrays, VBA does not. If you are using Excel 2002 and up, a better choice for "pinging" is to use the Windows Instrumentation Interface (WMI). Click on the link to see some code examples.

Ping using WMI

Sincerely,
Leith Ross

[Schwizer]

Much appreciated. Thank you

Schwizer