VBA to size textbox

[sadams1]

I'd like to active a textbox, (or several textboxes) & have a macro that will make it a specific height & width. Is it possible to do something like this? All the stuff I've found deas with autosizing to text.

 

[ranman256]

can you not size them in design mode manually?

 

[Johnny C]

Something along these lines ...
ActiveSheet.Shapes.Range(Array("TextBox 1")).Select
then use the ShapeRange properties. You can specify how far from the top of the worksheet is (Selection.ShapeRange.Top), how far from the left edge of the worksheet (Selection.ShapeRange.Left), the height (Selection.ShapeRange.Height) and (Selection.ShapeRange.Width)

These are the properties you can play with :-
https://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.shaperange_properties.aspx

if you don't necessarily know the name of the textbox you'd need to cycle through all the shapes in the worksheet Shapes collection until you find the textbox you need then select it and work on it.