copy Textbox to other sheets

neodjandre

Well-known Member
Joined
Nov 29, 2006
Messages
950
Office Version
  1. 2019
Platform
  1. Windows
Hello,

I have 'Sheet1' which contains a textbox.

I need to find a way to copy this textbox to all other sheets and make its size the same as the used range in each sheet.

Is this something that can be achieved?

thanks in advance,
Andy :)
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
Perhaps this can get you started:


Code will create a new text box on every sheet the same size and location as the used range. It doesn't copy the textbox on sheet1 but you can add the formatting to the code so they all are similar to it.


Code:
Dim sht As Worksheet

For Each sht In ThisWorkbook.Worksheets
    With sht
        .Select
        If Not .UsedRange.Cells.Count > 0 Then GoTo Continue
        .OLEObjects.Add(ClassType:="Forms.TextBox.1", Link:=False, _
            DisplayAsIcon:=False, Left:=.UsedRange.Left, Top:=.UsedRange.Top, _
            Width:=.UsedRange.Width, Height:=.UsedRange.Height).Select
    End With
Continue:
Next
End Sub
 
Upvote 0

Forum statistics

Threads
1,213,549
Messages
6,114,264
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top