Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

ScrollBar - left-Right

Posted on 2013-01-19
7
Medium Priority
?
782 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
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 
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

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

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

If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

598 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