Centre Label Text

[Sinbad]

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

        .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 ?

 

[texasalynn]

does this work?

.HorizontalAlignment = xlCenter

 

[Sinbad]

hi, where exactly would I type this i.. ie before my code, after ? in combination ?

I´m not getting it to work