[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 797
  • Last Modified:

ScrollBar - left-Right

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
Rayne
Asked:
Rayne
  • 5
  • 2
1 Solution
 
gowflowCommented:
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
 
gowflowCommented:
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
 
RayneAuthor Commented:
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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
gowflowCommented:
ok here it is with your scrollbar
gowflow
scrollMe.xlsm
0
 
gowflowCommented:
Did you try the last file posted ?
gowflow
0
 
RayneAuthor Commented:
Hello Gowflow,

I tried it now. It works gold :)

Thank you
0
 
gowflowCommented:
Your welcome gald it did what you wanted.
gowflow
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now