Exact Copy Multiple Cells without changing formula reference Auto Create References to Multiple Sheets Insert Bullets, Check Boxes and more.Select Duplicate or Unique Rows Select Blank Rows (all cells are empty) Super Find and Fuzzy Find in Many Workbooks Random Select.
Merge Cells/Rows/Columns without losing Data Split Cells Content Combine Duplicate Rows/Columns.
Reuse: Quickly insert complex formulas, charts and anything that you have used before Encrypt Cells with password Create Mailing List and send emails.The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
Then save and close the code window, now, when you scroll the worksheet to anywhere, the inserted textbox is always kept on the top right corner of the worksheet. Note: In this code, the TextBox1 is the textbox name you have inserted, please change it to your need.ģ. VBA code: Insert floating textbox in Excel: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Then right click the sheet tab which contains the textbox that you want to keep visible always, and choose View Code from the context menu, and in the opened Microsoft Visual Basic for Applications window, copy and paste the following code into the blank Module: First, you should insert a textbox from the Developer tab, click Developer > Insert > Text Box (ActiveX control), and then draw the textbox, and enter the information into the textbox as you need. To insert a floating textbox, here is also a VBA code to solve this task.ġ. Then save and close the code window, now, when you scroll the worksheet and click a cell, the table picture is always kept on the top right corner of the worksheet. Note: In this code, the Picure1 is the image name you have created, please change it to your need.Ĥ. VBA code: Insert floating table in excel: Private Sub Worksheet_SelectionChange(ByVal Target As Range) After converting the table to picture, then right click the sheet tab which contains the table picture that you want to keep visible always, and choose View Code from the context menu, and in the opened Microsoft Visual Basic for applications window, copy and paste the following code into the blank Module: In the popped out Copy Picture dialog box, select As shown on screen from the Appearance section, and choose Picture under the Format section, click OK to close the dialog, and then click a cell to output the picture, at last, press Ctrl + V to paste this picture, see screenshot:ģ. Select the data table that you want to keep visible, then click Copy > Copy as Picture under the Home tab, see screenshot:Ģ. There is no direct way for you to insert the floating table, so you need to convert the table data to an image, and then apply a code to finish it, please do as this:ġ. Insert floating textbox in Excel with VBA code Insert floating table in Excel with VBA code This may be an interesting task, this article, I will introduce a quick trick to solve it. If you have a table or a textbox with some important data which you want to always be visible on the worksheet screen even though when you scroll up or down the worksheet.
How to insert floating table or textbox in Excel worksheet?