The Best Center Vba Excel References. Step 3 − the 'developer' ribbon appears in the menu bar. This is a good way of centering a text over multiple.

After that, type a (.) dot to get the list of properties and methods and select. Xlhalign enumeration (excel) specifies the horizontal alignment for the object. Indicates which buttons to display when calling the msgbox function.