vba formula for line spacing inside a rectangle

[kareem2]

Hello, I am having a hard time decreasing the line spacing inside a rectangle
To be precise : I want to decrease the space between the upper horizontal line of the rectangle and the words inside the text zone of the rectangle (there is only one line of words)

PS: I am talking about a "rectangle" shape inside a cell

thank you for any attempt to help me solve the problem!

 

[Snakehips]

@kareem2 Welcome.

Have you tried:
Right click shape > Format Shape > Text Options tab
Text Box icon (3rd right) > Vertical Alignment > Top Middle (or whatever)
Adjust Margins as desired.

Hope that helps.

 

[kareem2]

@kareem2 Welcome.

Have you tried:
Right click shape > Format Shape > Text Options tab
Text Box icon (3rd right) > Vertical Alignment > Top Middle (or whatever)
Adjust Margins as desired.

Hope that helps.

Sir, thank you very much ! it worked like a charm !

for those wondering , I chose "vertical allignment : middle" .

good day !