Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I wonder if there is a way to use variables to iterate controls
(textbox) on a form via VBA i Exel, just as you can in Access Something Like: Dim ctrlS As Control ... For n = 1 to 60 strSkudd = "txtSkudd"& n Set ctrlS = Controls(strSkudd) .... Range("A1").Offset((i + intR) - 2, 6 + j) = ctrlS.Text .... This does not work, but is it posible, and how?? I have a form with plenty of textboxes (txtSkudd1, txtSkudd2 etc.. txtSkudd60) on which I want to write to a spreadsheet from and vice verse . Kjell s J |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
running same code with multiple controls | Excel Programming | |||
Running Code From Controls On Other Forms | Excel Programming | |||
how to access programatically added controls | Excel Programming | |||
Using same code for Multiple cmd Controls | Excel Programming | |||
Accessing ActiveX Controls using VBA - can't use Control.Name to access. | Excel Programming |