Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
You're welcome, Mhz !
.. or making use of a Floating text Box. I played with some past code by Orlando Magalhães Filho (below) and it seems to do the above nicely (I just found the code <g) Here's a sample file with the code implemented: http://www.savefile.com/files/7433679 Floating Textbox Example.xls Steps: Draw a text box (default named:"Text Box 1") on the sheet first Then install the code by right-clicking on sheet tab View code then copy n paste Orlando's code into the code window [ Adjust the x, y offsets to suit - I set these arbitrarily to 10] '--- Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) 'by Orlando Magalhães Filho in .programming x_offset = 10 y_offset = 10 ActiveSheet.Shapes("Text Box 1").Select With Cells(ActiveWindow.Panes(1).ScrollRow, _ ActiveWindow.Panes(1).ScrollColumn) xpos = .Left + x_offset ypos = .Top + y_offset End With With Selection .Left = xpos .Top = ypos End With Target.Select End Sub '--- -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Mhz" wrote: Thanks Max for the reply, I wish they would work on expanding the Freeze Panes or making use of a Floating text Box. My Format is already spaced for Optimized Width and It would be a bit more irritating to shift between windows, But none the less your method appears to be the best at hand ... Thanks ..;) |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
In the sample file, the demo textbox -- with the eye-catching classic Ferrari
thrown in as a bonus <g -- will remain fixed in the top left corner when we scroll down or across the sheet .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I get ONLY new info from 1 Worksheet to another automatical | Excel Worksheet Functions | |||
Concatenating info from several cells into the one above | Excel Discussion (Misc queries) | |||
Reflecting info between an excel file and a word one or two excel file. | Excel Worksheet Functions | |||
Reflecting info between an excel file and a word one or two excel file. | Links and Linking in Excel | |||
Reflecting info between an excel file and a word one or two excel file. | Excel Discussion (Misc queries) |