Solved

ScrollBar - left-Right

Posted on 2013-01-19
7
722 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
  • 5
  • 2
7 Comments
 
LVL 29

Expert Comment

by:gowflow
Comment Utility
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 29

Expert Comment

by:gowflow
Comment Utility
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
Comment Utility
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
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 
LVL 29

Accepted Solution

by:
gowflow earned 500 total points
Comment Utility
ok here it is with your scrollbar
gowflow
scrollMe.xlsm
0
 
LVL 29

Expert Comment

by:gowflow
Comment Utility
Did you try the last file posted ?
gowflow
0
 

Author Comment

by:Rayne
Comment Utility
Hello Gowflow,

I tried it now. It works gold :)

Thank you
0
 
LVL 29

Expert Comment

by:gowflow
Comment Utility
Your welcome gald it did what you wanted.
gowflow
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

744 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now