| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to desensitize the "X" on Inputboxs, Textboxes and other gui's
Good morning!
I find myself without my VBA bible, it is at work and I am at home....in it was a method to desenitize the "X" found on various boxes that can be build via VBA. To my horror I have found several field type people (read that as users) who are using this 'X' and blowing up my VBA utility. Can some one offer the fix for this that I can't quite remember and put me out of my misery? Thanks Wayne |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to desensitize the "X" on Inputboxs, Textboxes and other gui's
http://peltiertech.com/WordPress/200...-vba-userform/
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ wrote in message ... Good morning! I find myself without my VBA bible, it is at work and I am at home....in it was a method to desenitize the "X" found on various boxes that can be build via VBA. To my horror I have found several field type people (read that as users) who are using this 'X' and blowing up my VBA utility. Can some one offer the fix for this that I can't quite remember and put me out of my misery? Thanks Wayne |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to desensitize the "X" on Inputboxs, Textboxes and othergui's
On Jun 28, 2:13*pm, "Jon Peltier"
wrote: http://peltiertech.com/WordPress/200...he-red-x-close... - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ wrote in message ... Good morning! I find myself without my VBA bible, it is at work and I am at home....in it was a method to desenitize the "X" found on various boxes that can be build via VBA. To my horror I have found several field type people (read that as users) who are using this 'X' and blowing up my VBA utility. Can some one offer the fix for this that I can't quite remember and put me out of my misery? Thanks Wayne- Hide quoted text - - Show quoted text - Thanks Jon but I really do want to make the X not active in a similar manner as to when options are set to vbYesNo. Thanks for helping however. Wayne |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to desensitize the "X" on Inputboxs, Textboxes and othergui's
On Jun 28, 2:13*pm, "Jon Peltier"
wrote: http://peltiertech.com/WordPress/200...he-red-x-close... - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ wrote in message ... Good morning! I find myself without my VBA bible, it is at work and I am at home....in it was a method to desenitize the "X" found on various boxes that can be build via VBA. To my horror I have found several field type people (read that as users) who are using this 'X' and blowing up my VBA utility. Can some one offer the fix for this that I can't quite remember and put me out of my misery? Thanks Wayne- Hide quoted text - - Show quoted text - Thanks Jon but I really do want to make the X not active in a similar manner as to when options are set to vbYesNo. This is mostly an issue with inputbox I think. I can use your suggestions for other userforms. Thanks for helping however. Wayne |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to desensitize the "X" on Inputboxs, Textboxes and other gui's
Rather than "desensitize" the "X", you should allow the user to do that
(it's a common Windows thing to do) and set up your code to handle the action. If you are running from a UserForm, use the UserForm_QueryClose event to perform whatever clean-up code you now perform when your users click your current ExitButton/ExitMenuItem/etc. By the way, to answer your question, setting Cancel = True in this event will "desensitize" the "X" for you (but I strongly suggest you not do this as it makes your code seem unprofessional). If you are not using a UserForm, then put your clean-up code in the Workbook_BeforeClose (this event kicks off when the user closes Excel itself). Rick wrote in message ... Good morning! I find myself without my VBA bible, it is at work and I am at home....in it was a method to desenitize the "X" found on various boxes that can be build via VBA. To my horror I have found several field type people (read that as users) who are using this 'X' and blowing up my VBA utility. Can some one offer the fix for this that I can't quite remember and put me out of my misery? Thanks Wayne |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| How to desensitize the "X" on Inputboxs, Textboxes and other gui's | Excel Programming | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Highlight / "Selection" of AutoShape Text (Like SelStart for TextBoxes) | Excel Programming | |||
Hybrid Mode
