Centre Label Text

Sinbad

Board Regular
Joined
Apr 18, 2012
Messages
224
Maybe one of you fundies has a solution for me.

I created a frame in a userform and am setting the label of the frame via this code

Code:
        .ProName.Caption = (Cells(ActiveCell.Row, "L").Value & "       Projekt ID:" & Cells(ActiveCell.Row, "K") & "      " & "CPE" & Cells(ActiveCell.Row, "J").Value)

What I would like to do is one of two thing (either or.. not both)

1. Centre the whole string over the width of the frame

or if this does not work

2. Have the first part right aligned (Cells(ActiveCell.Row, "L").Value), then the seconf part centred (Projekt ID:" & Cells(ActiveCell.Row, "K") and the last part aligned to the right ("CPE" & Cells(ActiveCell.Row, "J").Value)

this like in Word we would do with the tab settings.

Any ideas ?
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Sinbad

Board Regular
Joined
Apr 18, 2012
Messages
224
hi, where exactly would I type this i.. ie before my code, after ? in combination ?

I´m not getting it to work :(
 
Upvote 0

Forum statistics

Threads
1,195,856
Messages
6,011,976
Members
441,661
Latest member
Pammie007

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top