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