Centering text in textbox.
Mornign all,
I currently have a macro that displays a textbox asking the user to please wait while the files are updated. It then runs a second macro to compile some reports. Then when everything is updated it deletes the text box. The problem I am having is getting the text in the text box to center horizontly and vertically so it appears in the middle of the box.
The code is:
Please Login or Register to view this content.
Last edited by CJPHX; 05-31-2010 at 12:48 PM.
There is usually no need to Select. I've removed a few Selects. The text alignment code is in red.
Please Login or Register to view this content.
Last edited by mikerickson; 05-31-2010 at 12:43 PM.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Mornign Mike,
I tried the text alignment and I got a "Compile Error: Invalid or unqualified reference". The selects I had in there at the end was so that the text box would delete itself after the files were done updating.
Sorry Mike. I pasted in the whole code you had set up instead of the alignment part and it is working wonderfully. thank you.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
royUK. Thank you, but I am showing that I already marked it as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks