So I have been having this same problem for a long time.
I just work around it, by scrolling with my mouse, which can be tedious.
We used to have MS 2016, now we have Office 365. Problem existed on both.
The document is a shared document, old school, not the internet sharing because I need to be...
Hi there!
So, I'm making an excel spreadsheet that has to have a lot of text in it, so I added a word object in it.
The issue is that it takes a lot of space on the screen and I need a way to reduce it without compromising the format of the text.
Also, the user needs to be able to do different...
I have created a pivot table with 3 columns: Order number, Officer, and Days Outstanding. I have filtered it to only show Days Outstanding > 5.
The problem is, I want to use this on a dashboard, where I need to fix the number of orders to 6. So, I was thinking that I need to somehow add a...
Hi,
Hopefully this is possible.
I'd like to hide the horizontal scroll bar in a specific worksheet.
The code below does it generally for all tabs, would appreciate some help tailoring it to only apply for the "Results" worksheet
Code - For All Sheets:
Private Sub...
I have a file and created 3 scrollbars to help my sales reps understand how they can affect their commissions by activities they can control. On the worksheetI have a section that shows their current performance, and another section that shows a 'What-If' scenario. As I move the scrollbars, the...
Hi all,
I'm using the following code to hide/show charts and scrollbars.
Private Sub cmbDepartment_Change()Dim SelectedChart As String
Dim SelectedScrollbar As String
Dim blnVisible As Boolean
Me.cmbFilter.ListFillRange = Me.cmbDepartment
Range("B16") = cmbDepartment.ListIndex + 1...
First off, I appreciate all of your time in reviewing and potentially responding to my inquiry.
I have a webpage that loads a modal that is longer than the page displays requiring me to scroll down to get the second screenshot. I have not been able to programmatically scroll the modal despite...
Hello Everyone,
I have few questions here
1. Just like what is in the subject line, I would like to learn how can I add a scrollbar within a frame that I created as well. Please see the code I created so that I can explain it further.
For counter = 0 To 10
Set MyFrame=...
Hi
Can I get a script to scroll the vertical scrollbar to the bottom of the list of a listbox?
I load the listbox each time I add data . So I will like to see the last item.
Thanks
I have a userform with a scrollbar and textbox. How do you code it so that the scrollbar connects to the textbox? For example, I want the textbox to increase/decrease by a value each time you click the up/down-arrow on the scrollbar. Anything helps!
I have listbox that adjust to screen resolution of user computer. Since it is also auto-fit it's columns in some cases scrollbar appear so user could view all columns in listbox!
Since I didn't want to use column header option of listbox I've put labels above listbox of each column.
Of course...
Hello,
Hope you are well.
I have a Userform with a 2100 height. On this Userform is Frame14 with a 2000 height and scrollbar set Vertically to a 1950 height. On Frame14 is 5 different Frames (Frame1, Frame2, ect).
What I want to do is if a user clicks the scrollbar the scrollbar should upon...
Folks,
I have to add both vertical and horizontal scrollbars in a userform, so far I have this code below for horizontal scrollbars only.
Private Sub UserForm_Activate()
With Me
.ScrollBars = fmScrollBarsHorizontal
.ScrollWidth = .InsideWidth * 1.5
End With
End Sub
The...
Hi all,
I have recently attempted to use the DetectScroll method developed by CPearson: http://www.cpearson.com/excel/DetectScroll.htm
It no longer works because it is based on the "WM_VSCROLL" messages, which I cannot find in any window's message stream using Spy++.
From this observation, I...
Hey guys,
I have a simple textbox (ActiveX control) on a sheet. I've set the Vertical Scrollbar property to true as well as Multiline. I've also gone through all the other properties of the textbox, but I cannot seem to determine what is causing the scrollbar to disappear when I close and...
I have an ActiveX ScrollBar and want to set the Max value to the contents of an Excel Cell so that it becomes variable. What is the VB coding? So far I have:
Private Sub ScrollBar1_Change()
Dim cell As Integer
cell = 200
ScrollBar1.Max = cell
End Sub
Which works. I now want to change the '200'...
Hello Everyone,
I'm sort've new to Excel and writing code in VBA. I have the following situation: my company tries to make revenue predictions at its many sites (740 sites). We are the midst of creating a forecast method and we'd like to compare the old one to the new one. So currently I have a...
My problem is illustrated in the PrintScreen below:
I've searched a lot on the Internet and almost all sources say to delete the empty rows at the end of the sheet and save the document. For example that is what is suggested here (see Section 2f) ...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.