Need help to CREATE a userform or sort of to FLOAT! :)

[pedie]

Is that possible?? In excell 2003, I use validation to be floating so that wherever I move across the sheet I want whatever is written the validation (comment) is visible and floats in top corner...and help me in remembering thing/formula etc......

Please advice

 

[pedie]

my idea may be vague but .....i;m sure there's a way...!

 

[pedie]

I got this code from somewhere...it is giving me error....
I suppsoe this code is to make the button always go along with & float

Option Explicit

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.CommandBars("Form").Delete
End Sub
'********************************
Private Sub Workbook_Open()
On Error Resume Next
Application.CommandBars("Form").Delete
On Error GoTo 0
With Application.CommandBars.Add("Form", , False, True)
    With .Controls.Add(msoControlButton)
         .TooltipText = "Show Form"
         .Style = msoButtonCaption
         .Caption = "Show Userform"
         .OnAction = "ShowForm"
         .BeginGroup = True
    End With
.Protection = msoBarNoCustomize
.Position = msoBarFloating
.Visible = True
End With

End Sub

Private Sub ShowForm()
UserForm1.Show
End Sub

 

[mikerickson]

Pedie, I'm not sure what you are looking for.
It sounds similar to cell comments, or perhaps you want Excel to emulate Stickies.

 

[pedie]

Hey Mike...!


I just want something to be visible & floating in the excel sheet no matter where in the sheet i am. like when we freeze it...but i dont want to freeze it...i want a button sort of thing to be floating and visible no matter where i scroll to....



please H.E.L.P

 

[mikerickson]

A modeless userform in the Personal Macro Workbook would be one way to do that.

 

[pedie]

Guys! got to make it work....

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range , Cancel As Boolean )

I have made the userform appear on the right side of the cell whenever i double click on it....

that also serves the purpose...