Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use code in a modul
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use code in a modul
Instead of If "chk_ci" & i.Value = True Then use Me.Controls("chk_ci" & CStr(i.Value)).Value = True Then Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Tue, 12 May 2009 13:31:03 -0700, alvin Kuiper wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use code in a modul
Check your older thread.
alvin Kuiper wrote: 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 -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use code in a modul
Where are your checkboxes?
On a worksheet or in a userform? If they're on a userform, see your other thread. If they're on a worksheet, what type are they? Are they from the Forms toolbar or from the Control toolbox toolbar? And where is this code? Is it behind a worksheet (called from a click of a commandbutton from the control toolbox toolbar)? Or is it in a General module (called from click of a button from the Forms toolbar)? alvin Kuiper wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |