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