1

Topic: VBA EXCEL

It is necessary to create a type cycle

Dim i As integer
Dim k As Integer
i = 1
k = 3
For i = 1 To 49 Step 1
If LaboratorForm. CheckBox (i).Value = True Then
ListRow. Range (k) = "+"
Else
ListRow. Range (k) = ""
End If
i = i + 1
k = k + 1
Next i

The moderator: we Learn to use tags of design of the code - FAQ
does not recognize ChekBoksy
What way out?
At once I say that I not skilled , most likely the self-educated person  to implement something in the

2

Re: VBA EXCEL

vovana1 wrote:

Ehsel does not recognize ChekBoksy

And produces the message - "you  is not recognized"?

3

Re: VBA EXCEL

Generally, like VBA-shnye forms would not support arrays , whence there an index?

vovana1 wrote:

CheckBox>>> (i) <<<

4

Re: VBA EXCEL

Shocker. Pro;
So in it and a question as it is possible to do without

5

Re: VBA EXCEL

vovana1 wrote:

so in it and a question as it is possible to do without

Everything that we know about your task, it

vovana1 wrote:

It is necessary to create a type cycle

are glad to help, yes only the distinct question is not present

6

Re: VBA EXCEL

Shocker. Pro;
Really, the question turned out any not clear
I work at Health Centre
I want to adjust the registration in laboratory
At me on the form 49 Chekboksov
Let's admit the patient comes also to it do three analyses
The operator pushes three flags
All data should get to the table
Basically I can make 49 times check how many flags is installed
But it turns out very long
Therefore I wanted through a cycle all it to make
But it is impossible
In the written code the error is produced
And as further  I do not know

7

Re: VBA EXCEL

vovana1;
Probably, it should help to understand a principle: How quickly to fill/clear elements on the form (TextBox, ComboBox)

8

Re: VBA EXCEL

vovana1 wrote:

At me on the form 49 Chekboksov

and when the new type of the analysis dobavljaetsja/is deleted - the manager of the programmer will call?
Whether it was easier to use ?

9

Re: VBA EXCEL

The_Prist;
Many thanks, all turned out

10

Re: VBA EXCEL

Shocker. Pro;
Thought good
But ChekBoksami is more evident and that is important the operator sees all names;
And  it is necessary to look through titles

11

Re: VBA EXCEL

At 49 names to see at once all - the interface nonsense.
At such amount it is time to enter a categorizing

12

Re: VBA EXCEL