Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi i use this on a checkbox event
Dim i As Integer Dim a As Integer a = 0 For i = 1 To 4 If Me.Controls("chk_ci" & i).Value = True Then a = a + 1 End If Next This works but if i make the code in a modul and use it i get an error on ME - and if i delete me I get an error on Controls and if I just use : If "chk_ci" & i.Value = True Then Then i get an error on the varable i Can someone help here? Alvin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Shorten code to apply to all sheets except a few, instead of individually naming them, and later adding to code. | Excel Programming | |||
Change name on modul | Excel Programming | |||
User form/Modul | Excel Programming | |||
File protect via extern USB crypto modul? | Excel Programming | |||
Error message:"Compile error modul 1" | Excel Programming |