Hi ilyaskazi,
Welcome to VBAX. To make both the worksheet and userform active requires Office 2000 or greater. By default your userform is shown modally (which is what you've described) - put False after your "Show" command e.g.:
to show it non-modally.Userform1.Show False
If you have Office '97 this will not work (although there is another method to simulate non-modal userforms in 97)
HTH
John
You know you're really in trouble when the light at the end of the tunnel turns out to be the headlight of a train hurtling towards you
The major part of getting the right answer lies in asking the right question...
Made your code more readable, use VBA tags (this automatically inserts [vba] at the start of your code, and [/vba ] at the end of your code) | Help those helping you by marking your thread solved when it is.
Posting Permissions
Reply With Quote