Thread: [Solved] Checkbox in Userform
View Single Post
 
Old 02-18-2014, 05:20 AM
lukael lukael is offline Windows 7 64bit Office 2007
Novice
  
Join Date: Feb 2014
Posts: 7
lukael is on a distinguished road
Default
I have found solution, thanks anyway !!!

Solution :

http://www.mrexcel.com/forum/excel-q...ml#post3720908

or in code:

Code:
Option Explicit

Private Sub UserForm_Initialize()
Me.CheckBox1 = application.WorksheetFunction.CountA(Sheet1.Range("E4,E6")) = 2
End Sub
Reply With Quote