View Single Post
 
Old 04-30-2020, 07:14 PM
marceepoo marceepoo is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Sep 2012
Posts: 22
marceepoo is on a distinguished road
Default

Quote:
Originally Posted by gmayor View Post
It sounds as though the errant text box is either off the form area where it is supposed to be or hidden behind another element. Select the element where the text box was placed e.g. Userform, Frame etc and check its properties in the Properties dropdown. All the items that element contains should be listed. Select the 'missing' item in that list and you should be able to locate its position in the editor bring it back into view.
Graham, you are absolutely right, as shown in my posting Today, April 30, 2020, at 06:46 PM, i.e., the errant text box is off the form area where it is supposed to be.

Until about 5 min ago, I didn't understand your suggestion:
Quote:
Select the element where the text box was placed e.g. Userform, Frame etc and check its properties in the Properties dropdown. All the items that element contains should be listed.
But after I started doing what you told me to do, it became obvious and wonderful. I saved the new location coordinates in the VBA IDE, and now I can resume working on the userform.

If it won't take more than a few moments of your time or Guessed's time, I would like to know how to use VBA to save those values to the userform. If it takes more than a few moments, don't bother. You both have been very helpful, and I don't want to take advantage of you.

Marc

Thanks again, to both of you.
Reply With Quote