Create a UserForm, leave the name as "UserForm1"
On that form, create a large TextBox, leave the name as "TextBox1"
Change the following TextBox properties:
EnterKeyBehavior to True.
MultiLine to True.
Add this code to userform:
Option Explicit
Private Sub...
The need to minimize Excel and still have a small (child) window present, and always on top (always on top, right?) might be doable.
I run two monitors, so that situation never occurs. I just park Excel on one monitor, let it do what it wants to do, and proceed with another application located...
Are you currently serving the Excel?
Meet the guy halfway, scrounge up some older system and dedicate it to Access.
Actually, the skeptic should allow a short-term test to see if anyone can truly perceive the difference.
Have all the field names obey a naming convention, perhaps the textboxes all start with "Text", all the listboxes start with "List", etc. For my example I use the first four characters of each name. If you don't want to clear the field, then don't name it according to your...
Yes I do.
Provide more detail (which application?), any restrictions (is a userform with large textbox OK?), what has failed, etc.
I will respond.
Steve
More detail, please.
Have you Googled the exact phrase? What comes back?
What exactly is the code doing? It works on other machines, right?
What are the differences between the problem machine and the good machines?
What are the additional references, if any, the project requires?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.