TextFrame.VerticalAlignment (Excel)

Returns or sets an XlVAlign value that represents the vertical alignment of the specified object. Possible return values are xlVAlignBottom - Bottom, xlVAlignCenter - Center, xlVAlignDistributed - Distributed, xlVAlignJustify - Justify, xlVAlignTop - Top.

Some of these constants may not be available to you, depending on the language support (U.S. English, for example) that you've selected or installed.

Dim tfe As TextFrame: Set tfe = 
tfe.VerticalAlignment = xlVAlignBottom