• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

User Form Title (Caption) Left Alignment

Debraj

Debraj

Excel Ninja
Hi Forum,

How to align User Form Caption as Left Alignment..

Actual :
Actual.png

Expected:
Expected.png

I have seen, few form's caption as Left Alignment.. but which property need to change...

PS: obviously, Expected Image is activated by Photoshop :)
 
Hi,
Mentioned post is related to set label's position to center in form, dynamically..
Not related..
:-(
 
I'm confused
In Excel 2010 VBA User Forms have there text left justified by default

Userform Pic.PNG
 
Hi, Debraj(ex-Roy)!
I agree with Hui, normally it's left aligned.
And to center it... why making it difficult? Just add the required spaces at the beginning of the user form's caption... et voilà!
Regards!
 
Interesting..
I have Win 8, with Office 2013.
Default Alignment for User Form Caption is Center..
can you please upload a sample file with a single line userform1.show
Just want to view it in my environment..

Here is mine..
 

Attachments

  • User Form.xlsm
    14.4 KB · Views: 41
Hi, Debraj(ex-Roy)!
You definitively have a problem with something.
Apart from Windows 8, just to start with.
Regards!
 
Hi Debraj,

Is that the Windows theme causing this? Worth checking by changing the theme to something similar of Windows7 etc.,
 
Hi Lohit,
Thanks for the suggestion, but Win 8, dont have that much of flexibility, like setting color for active window, set backcolor for inactive window.. Aero effect all takes it.. :)

I dont think, its a matter of windows.. I think I need to re-install VB6 (right now Not installed), to check actual property of Window frame or need to download ="Microsoft Office " & <15 & "Object Library" :)

Any suggestion, are appreciate..
 
Hi, Debraj(ex-Roy)!
Why don't you install an OS? Rather than Windows 8 I'd try with Vista... :p
... or if you prefer Me... :D
Regards!
 
Good day Debraj

This is the RightToLeft property, turn from false to true.
 

Attachments

  • Capture.JPG
    Capture.JPG
    16.2 KB · Views: 35
The RighttoLeft propoerty is an Excel Screen/window property which will also make Column A on the right and Column Z on the left of your screen
I don't think that solves the Userform Title justification ssue
 
You must log in or register to reply here.
Back
Top