You said you had a userform with a dropdown DD1. A userform is a class module with properties, methods and events. If you have a dropdown in your Userform then there is a click event for that dropdown. If you have a command button in the userform then there is a click event for that command button.
Put the code I sent to you in one of those events.
Look at the create and employ a userform tips page on my website.
|