Text box that moves when scrolling

[glad_ir]

Hello everybody,

I’m hoping for some help please. I’d like to achieve a text box or text in a row that centres on the screen as the user scrolls horizontally but moves with the row when they scroll vertically.
Is this even achievable? Any thoughts much appreciated.

thank you, Iain

 

[My Aswer Is This]

I have no answer for what you want as far as scrolling.
But this script will move the TextBox as you select different cells.
Try this and see if this will work.

This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on the sheet tab
Select View Code from the pop-up context menu
Paste the code in the VBA edit window

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'Modified  11/23/2020  10:22:06 PM  EST
    TextBox1.Top = ActiveCell.Offset(2).Top
  If Target.Column > 3 Then TextBox1.Left = ActiveCell.Offset(, -2).Left
End Sub

 

[My Aswer Is This]

You may want to play around with the code a little to get the textbox positioned exactly where you like. You should see the ideal of how it works.

 

[glad_ir]

You may want to play around with the code a little to get the textbox positioned exactly where you like. You should see the ideal of how it works.

Hi, thank you for replying. I am getting a debug error when I try to run this. Any thoughts? Could well be me doing something wrong. I have a TextBox1 in the sheet and have pasted the macro in the worksheet as suggested. Thank you

 

[My Aswer Is This]

Is it causing a error all the time or just when you click on certain cells.
It works for me.
Are you using a Activex Textbox?

 

[glad_ir]

Hi.....it's causing an error when I click on a cell. I've inserted a textbox - not sure if it's an Active Textbox. Please could you advise how I insert one of these. Sorry - real newby here!

 

[My Aswer Is This]

Hi.....it's causing an error when I click on a cell. I've inserted a textbox - not sure if it's an Active Textbox. Please could you advise how I insert one of these. Sorry - real newby here!

Well put the Textbox on the sheet before putting the code in the sheet
Do not understand:
how I insert one of these

 

[glad_ir]

Is it causing a error all the time or just when you click on certain cells.
It works for me.
Are you using a Activex Textbox?

Hi - I've managed to insert a ComboBox using the Developer tab and modified the code from TextBox to ComboBox. It's not erroring but isn't moving the box.

 

[My Aswer Is This]

Are you sure your not still in Design Mode?
Is Your Workbook Macro Enable?
Have you ever used Vba Before?

 

[glad_ir]

Are you sure your not still in Design Mode?
Is Your Workbook Macro Enable?
Have you ever used Vba Before?

Hi - thank you for your patience.....it is now working now I've fixed my incompetence (had left myself in design mode)!! I have done some very basic VBA coding but nothing of this complexity. I'm discovering ActiveX controls for the first time.....lots to learn. Thank you very much for your help. I really appreciate it