LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 58
Default Scroll bar with text box

On Nov 9, 2:08*am, art wrote:
Hello:

I would like to make a scroll bar that while dragging the bar up or down a
small text box should appear and display which value the scroll bar is?

Is it possible?

Thanks.


This works for me on a UserForm.
Add a label that is positioned over the scrollbar. Set it's visible
property to false. Call it lblValue.

In the ScrollBar Scroll event:
Private Sub ScrollBar1_Scroll()
With Me.lblValue
.ZOrder (0)
.Caption = ScrollBar1.value
.Visible = True
End With
End Sub

In the ScrollBar ChangeEvent:
Private Sub ScrollBar1_Change()
Me.lblValue.Visible=False
End Sub
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Scroll bar adding to text box Ruth Excel Discussion (Misc queries) 2 October 1st 08 04:51 PM
Scroll bar not appearing in text box robs3131 Excel Programming 1 February 25th 08 02:17 AM
Copying text within text box and having scroll bar appear robs3131 Excel Programming 2 February 18th 08 10:58 AM
Text box w/ scroll ability [email protected] Excel Programming 0 April 5th 07 04:15 PM
Text Box w/Scroll Bar Chip Excel Discussion (Misc queries) 2 December 12th 06 12:08 AM


All times are GMT +1. The time now is 05:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"