Floating textbox/label

[Jock]

Is it possible to add a 'floating' label or text box to a worksheet so that,
as the user scrolls down or tabs accross, it remains visible at all times?
Thanks,

 

[Bob Phillips]

Yes, select the cell in column A below the label, and Windows>Freeze Panes

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Jock]

Thanks Bob. I was looking for something a little more adventurous though
--
Traa Dy Liooar

Jock

Yes, select the cell in column A below the label, and Windows>Freeze Panes

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Rick Rothstein \(MVP - VB\)]

You could use a UserForm to hold your TextBox and/or Label... set the
UserForm's ShowModal property to False.

Rick

Thanks Bob. I was looking for something a little more adventurous though

 

[Bob Phillips]

Create an un docked commandbar.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

Thanks Bob. I was looking for something a little more adventurous though

 

[sadi]

Use this code for a text box from control tool box

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
With ActiveWindow.VisibleRange
TextBox1.Top = .Top + 5
TextBox1.Left = .Left + .Width - TextBox1.Width - 45
End With
End Sub




Joc wrote:

Floating textbox/label
17-Dec-07

Is it possible to add a 'floating' label or text box to a worksheet so that
as the user scrolls down or tabs accross, it remains visible at all times
Thanks
-
Traa Dy Liooa

Jock

Previous Posts In This Thread:

Floating textbox/label
Is it possible to add a 'floating' label or text box to a worksheet so that
as the user scrolls down or tabs accross, it remains visible at all times
Thanks
-
Traa Dy Liooa

Jock

Yes, select the cell in column A below the label, and Windows>Freeze Panes--
Yes, select the cell in column A below the label, and Windows>Freeze Pane

-
--
HT

Bo

(there is no email, no snail mail, but somewhere should be gmail in my addy)

Thanks Bob.
Thanks Bob. I was looking for something a little more adventurous though :
-
Traa Dy Liooa

Joc

:

You could use a UserForm to hold your TextBox and/or Label...
You could use a UserForm to hold your TextBox and/or Label... set th
UserForm's ShowModal property to False

Rick

Create an un docked commandbar.
Create an un docked commandbar

-
--
HT

Bo

(there is no email, no snail mail, but somewhere should be gmail in my addy)


Submitted via EggHeadCafe - Software Developer Portal of Choice
What's New for Developers in SharePoint 2010 Object Model?
http://www.eggheadcafe.com/tutorial...d8-3e2773fa29b5/whats-new-for-developers.aspx

 

[joel]

You could put the Text box on a Userform and make the userform Modeles
so it will float. You would have to go into VBA and on the menu Inser
Userform then use the Userform toolbox to add objects like Listboxes o
Textboxes.

When you start the userform use this code in the module that starts th
userform

UserForm1.Show vbModeless