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 Liooar

Jock

Yes, select the cell in column A below the label, and WindowsFreeze Panes

--
---
HTH

Bob


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



"Jock" wrote in message
...
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 Liooar

Jock

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

Jock


"Bob Phillips" wrote:

Yes, select the cell in column A below the label, and WindowsFreeze Panes

--
---
HTH

Bob


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



"Jock" wrote in message
...
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 Liooar

Jock

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

Rick


"Jock" wrote in message
...
Thanks Bob. I was looking for something a little more adventurous though
:)
--
Traa Dy Liooar

Jock


"Bob Phillips" wrote:

Yes, select the cell in column A below the label, and WindowsFreeze
Panes

--
---
HTH

Bob


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



"Jock" wrote in message
...
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 Liooar

Jock

Create an un docked commandbar.

--
---
HTH

Bob


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



"Jock" wrote in message
...
Thanks Bob. I was looking for something a little more adventurous though
:)
--
Traa Dy Liooar

Jock


"Bob Phillips" wrote:

Yes, select the cell in column A below the label, and WindowsFreeze
Panes

--
---
HTH

Bob


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



"Jock" wrote in message
...
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 Liooar

Jock

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 Liooar

Jock

Previous Posts In This Thread:

On Monday, December 17, 2007 7:43 AM
Joc wrote:

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 Liooar

Jock

On Monday, December 17, 2007 8:25 AM
Bob Phillips wrote:

Yes, select the cell in column A below the label, and WindowsFreeze Panes--
Yes, select the cell in column A below the label, and WindowsFreeze Panes

--
---
HTH

Bob


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

On Monday, December 17, 2007 8:56 AM
Joc wrote:

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

Jock


"Bob Phillips" wrote:

On Monday, December 17, 2007 12:38 PM
Rick Rothstein \(MVP - VB\) wrote:

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 the
UserForm's ShowModal property to False.

Rick

On Monday, December 17, 2007 12:58 PM
Bob Phillips wrote:

Create an un docked commandbar.
Create an un docked commandbar.

--
---
HTH

Bob


(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/tutorials...evelopers.aspx

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

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

UserForm1.Show vbModeless


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=186164

Excel Live Chat