I use this code to add textbox to my excel sheet
- Code: Select all
Dim tb1 As Core.ITextBox = sheet.TextBoxes.AddTextBox(row, col, h, w)
The textbox added is aligned to the left side of the cell. Is there a way to align the textbox to the centre of the cell?