Checkbox in Userform

macropod · #1 02-18-2014, 04:55 AM

I don't see why you'd want to add that code to a userform, since it already runs automatically when the worksheet is changed. Still, if that's all you want to do, simply call it from your userform, passing whatever range you want to use as the target.

lukael · #2 02-18-2014, 05:03 AM

Quote:

Originally Posted by macropod

I don't see why you'd want to add that code to a userform, since it already runs automatically when the worksheet is changed. Still, if that's all you want to do, simply call it from your userform, passing whatever range you want to use as the target.

I have post this code in Initialize and Activate event of Userfom, but nothing happens. I get Error 424-Object required !

My guess, this line is the problem :

Code:

If Target.Count = 1 Then

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