Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 124
Default Userform and scroll bars

Hi

I have a user form that I have added the vertical scroll bar to by using the
properties.
However , the scroll bar does not work..

Is there something else I need to do??

Thanks in advance!
Kimberly


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Userform and scroll bars

Is any of the userform not visible? If not, then there would be nothing to
scroll to.

--
Regards,
Tom Ogilvy

"KimberlyC" wrote in message
...
Hi

I have a user form that I have added the vertical scroll bar to by using

the
properties.
However , the scroll bar does not work..

Is there something else I need to do??

Thanks in advance!
Kimberly




  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 63
Default Userform and scroll bars

Hi KimberlyC;
For example:

Private Sub UserForm_Initialize()
' Vertical ScrollBar
Me.ScrollHeight = Me.InsideHeight * 3
' Horizontal ScrollBar
'Me.ScrollWidth = Me.InsideWidth * 3
End Sub

MP

"KimberlyC" a écrit dans le message de
...
Hi

I have a user form that I have added the vertical scroll bar to by using the
properties.
However , the scroll bar does not work..

Is there something else I need to do??

Thanks in advance!
Kimberly




  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 124
Default Userform and scroll bars

Hi
I figured it out.. I changed the scroll height to match the form height and
that seemed to work...
"KimberlyC" wrote in message
...
Hi

I have a user form that I have added the vertical scroll bar to by using

the
properties.
However , the scroll bar does not work..

Is there something else I need to do??

Thanks in advance!
Kimberly




Reply
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 bars disappeared Sandra Excel Discussion (Misc queries) 1 July 30th 09 04:19 PM
scroll bars Cutearmychic Excel Worksheet Functions 1 August 22nd 08 08:53 PM
SCROLL BARS GSB Excel Discussion (Misc queries) 1 September 28th 07 05:03 PM
Scroll bars Tazzy via OfficeKB.com Excel Discussion (Misc queries) 3 December 10th 06 10:28 PM
Scroll bars Embalmer Excel Discussion (Misc queries) 1 December 31st 05 05:05 PM


All times are GMT +1. The time now is 12:00 AM.

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"