Why use code to prevent using the userforms X? It's unnecessary because your close button only closes the form, there's nothing else essential performed when the form closes.
Use Comboboxes to eliminate user input error & to make the code easier
Why use code to prevent using the userforms X? It's unnecessary because your close button only closes the form, there's nothing else essential performed when the form closes.
Use Comboboxes to eliminate user input error & to make the code easier
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
I modified your macro but royUK's suggestion is the ideal.
Regards,
Antonio
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks