Checkbox in Userform

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Checkbox in Userform

FAQ

Thread Tools

Display Modes

02-18-2014, 05:07 AM

lukael

Windows 7 64bit Checkbox in Userform

Office 2007

Novice

Join Date: Feb 2014

Posts: 7

Quote:

Originally Posted by macropod

Have you specified the target range?

this is from the code above, range:

Code:

If Target.Count = 1 Then 
        If Not Intersect(Target, Range("C4,C6")) Is Nothing Then 
            blnValue = WorksheetFunction.CountA(Range("C4,C6")) = 2

It must tick checkbox ONLY IF both cells (C4,C6) are not blank - which is thier default value !

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Userform Code not quite right - help please	vbanovice	Word VBA	1	09-29-2013 09:20 PM
Help with a drop down in userform and variables	leemoreau	Word VBA	1	09-14-2013 06:01 AM
How to use the SaveAsDialog after UserForm is closed	drod	Word VBA	0	03-03-2013 08:06 PM
Outlook userform validation help	aiwnjoo	Outlook	0	12-08-2010 12:57 AM
Checkbox on Userform result in Text in Word	Dolfie_twee	Word VBA	1	06-22-2010 07:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:08 AM.