Excel problem

[w4tc]

Hello buddy's

xD at this moment i a little stock on excel
i have a checkbox that called "Wedstrijdgroep" ( sorry dutch name  in english is it : "Matchgroup" )

i wanne make a group a cell ( B24 : B28 )
there ar numbers in it ect
but if my checkbox Matchgroup is not checked
must it be hidden so i use ;;;
and is it checked it must be visible
so i tried it in a macro, but somereason it dont works  
can somebody help me?

here is the code :

Code: [Select]

Sub macro1()
'
'
If Wedstrijdgroep = True Then
    Range("B24:B28").Select
    Selection.NumberFormat = "General"
    Else: Range("B24:B28").Select
    Selection.NumberFormat = ";;;"
End If
End Sub
thx for the help!
Frederik
W4tc

[Pilchard123]

This is in VBA, yes?

Which version of Excel are you using?

[w4tc]

Yes, i use office 2007
but normale to use vba ect. the version is not not always important.
I think that for this not realy important is?

[Pilchard123]

Code: [Select]

Sub macro1()
If Wedstrijdgroep.Checked = True Then
Range("B24:B28").Select
Selection.NumberFormat = "General"
    Else
Range("B24:B28").Select
Selection.NumberFormat = ";;;"
End If
End Sub


Try that. I don't know much VBA, but I'm passable-ish in VB.NET