?
Solved

ScrollBar - left-Right

Posted on 2013-01-19
7
Medium Priority
?
769 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 31

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 31

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 Admins - 7 Day Trial

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 31

Accepted Solution

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

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 31

Expert Comment

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

Featured Post

Office 365 Training for Admins - 7 Day Trial

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.

Question has a verified solution.

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

This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

762 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