Solved

ScrollBar - left-Right

Posted on 2013-01-19
7
764 Views
Last Modified: 2013-01-20
Hello All,

I am trying to do a horizontal scrollbar from form controls like shown in attached.
As users scroll left to right or right to left, thigs happen and row moves
Like if user scroll from 1 to 7 in the scrollbar, the topmost row that table with column [relpos] = 7 shows up at the top
I need a VBA to accomplish this.

Thanks
R
scrollMe.xlsm
0
Comment
Question by:Rayne
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 2
7 Comments
 
LVL 30

Expert Comment

by:gowflow
ID: 38797832
Sorry but don't understand quite what you want to acheive. By default Excel put horizontal and vertical scroll bars why would you add a scroll bar ??

You put a horizontal scrollbar that should move columns but you refer to moving rows how is that ???
gowflow
0
 
LVL 30

Expert Comment

by:gowflow
ID: 38797878
Well don't know if this is what you want. I inserted on row 1 a diffrent scrollbar and enable macroes and check if this is what you want.
gowflow
scrollMe.xlsm
0
 

Author Comment

by:Rayne
ID: 38797906
Thank you Gowflow, this is EXACTLY what I wanted. but one question: You used a activeX control - is there any way you could change the code to do this on a regular form control (I am avoiding ActiveX due to resizing issues) - Is that possible?

Let me know please

Thank you
0
Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
LVL 30

Accepted Solution

by:
gowflow earned 500 total points
ID: 38797936
ok here it is with your scrollbar
gowflow
scrollMe.xlsm
0
 
LVL 30

Expert Comment

by:gowflow
ID: 38798832
Did you try the last file posted ?
gowflow
0
 

Author Comment

by:Rayne
ID: 38798912
Hello Gowflow,

I tried it now. It works gold :)

Thank you
0
 
LVL 30

Expert Comment

by:gowflow
ID: 38798935
Your welcome gald it did what you wanted.
gowflow
0

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This article describes a serious pitfall that can happen when deleting shapes using VBA.
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question