I am building a form for use in Excel. The form is going to be rather long. I want to use the vertical scroll bar, but I can't seem to get it to work.
Besides enabling the vertical scroll bar, what other steps do I need to take in order to utilize this feature?
I created the following worksheet when a user opens my workbook:
Project #Project DescProject LeaderStatus Date
1Project Desc 1Jones02/04/2014
2Project Desc 2Jones02/21/2014
5Project Desc 5Smith02/04/2014
[Code] ........
I now need to take the worksheet fields and place them in a userform which will have the following:
View command button which has the hyperlink attached to it followed by boxes with the Project Desc, Project Leader and Status Date.
I have a userform which has vertical and horizontal scroll bars. I want to set the scroll bar width and height properties to the correct value, regardless of the size of monitor screen used to look at the user form. I'm thought of using the code below in the initiliaze event for the user form:
Me.ScrollHeight = Me.Height
Me.ScrollWidth = Me.Width
However, this does not seem to work. I've tried adding 250 (Me.Height + 250)to each measurement, which works, but gives the user with the larger screen a very big scroll area. I wondered if there was a formula based on the application height, that would allow the scroll height to be perfect for the user form regardless of screen size?
Rico.
PS. I also use the following code to set the user form height on initialize. I don't know if that effects anything.
Me.Height = Application.Height
Me.Width = Application.Width
I have seen some code around that allows scrolling in listboxes using the mousewheel. I have also seen some code here on the forums about scrolling through a combobox embedded in a workbook. I have tried adapting both of these to suit a combobox on a userform but I cannot get either to work.
Here is the code that I used for the embedded combobox; I added it to the base code for the userform
I then added the following code to a standard module as stated in the forum post;
In the first section of the code there is a msgbox that never gets shown so I don't think code is recognizing the mouse wheel at all.
The second set of code that I used was set up to work with a listbox and it works perfectly with a listbox control. The problem is I cannot adapt it to suit a combobox and if I use a breakpoint to see what is happening Excel freezes.
The following code is added to the userforms code;
Then in a standard module I added the following code;
I added this section of the code;
I think this should only work on a Combobox but a Combobox does not appear to support the TopIndex value. Is there a way this can be setup to work with a userform combobox?
Sorry about the huge amount of code.
I am using the toolbox/ properties method to restrict the scroll area in the sheets of my workbook. However, for some sheets when i keep the right hand arrow pressed, the screen will not scroll to the last column. (i.e. the screen display will not move with the selected cell box)
View 2 Replies View RelatedIn the menu via TOOLS-->OPTIONS-->VIEW I am trying to remove the scroll bars from just one worksheet but when unticked, this option affects all of the worksheets in my workbook. Is there a way to just nail this selection down to one sheet via properties?
View 2 Replies View RelatedI am trying to make a scroll box so I can enter data into the scroll box dirrectly. Such a simple thing.
View 11 Replies View RelatedI'm trying to scroll down my work sheet but it's not letting me. Every time I move the scroll bar down the page it just keeps showing me the same part of the sheet eg cells 1-30 when I want to see all the way down to the bottom. I have some 20,000 lines I need to scroll through but I can't see all of them. To add to this, I keep having lines hide between other lines so theres a big gap like going from line 120 to line 4000 and I have to manually unhide them every time to see them.
View 2 Replies View RelatedDoes anybody know how to force the scroll bar on a listbox to be at the bottom rather than the top when filled with data?
View 6 Replies View RelatedI have a spreadsheet with some scripting that automatically emails the report to whoever is on the sheet. I'm not sure what kind of scripting it is. I think my boss found it somewhere.
Whenever I scroll either down or up, the first 3 rows disappear and I'm not able to scroll back up. The scrollbar shows that I'm not at the top, but it won't let me go back up. The first 3 rows contain the button to send the email. If I close out without saving and open it again, its fine, until I scroll up or down.
I've been trying to set the scroll bar min/max/small change to a decimal (percentage value) within the properties, obviously this does not work.
Since users can enter a value in the link cell for the scroll bar, how can I modify the current min/max/small change via macros so the scroll bar will show a min on 1%, small change of 0.25% and max of 25%?
Simple VBA What is the command to scroll to over "x" number of columns? and/or rows?
I just the active cell to move over 5 cells to the right for example?
I use a very simple textbox in a userform for sequential output only (it displays status messages of a long program run). The box nicely scrolls vertically up the lines but only till the userform has the focus (i.e. it is the actual selected window). But when I change the focus to othe window - scrolling immediatelly stops. Unfortunatly when I activate a new Excel sheet in the background program, the userform lost the focus and scroll is stopping.
Has anybody a solution for it? I have already tried positioning the textbox with sellength/selstart but I was unable to start the scrolling again from the proper position. I know that VB has the scrolltocaret() funcion but it is missing in VBA.
I have a document that is rather simple but has 32,984 Rows.
What I would like to do is program the sheet so if I enter a six (6) digit employee number in A2 (A1 is a header) then all the rows would scoll up and stop just below A2 in other words strop at row 3, if this makles any sense,
Also what I woudl like to do is the same option in A2 and have the same effect but here the user would have to enter only the first 3 characters of a name and then the system would scroll through all the options and start listing them as above starting at row 3.
The end result for both options would be to highlight the desired sorted rows..............
I am attempting to create a lookup spreadsheet. The big picture is this: I need a quick way to look up what paperwork i have and what i still need for each of my 200+ clients. I have created checkboxes and a document matrix where document names get color coded when a checkbox is checked next to clients name. Now i am attempting to add another feature where when the box is checked off i can see notes ive put in for that client. I picture it as a textbox with a scrollbar linked to a cell on a different sheet where the notes are stored. I cannot to get it to work, i am able to insert the textbox but the notes appear in a single Line, no matter how big the texbox is, which makes the scroll bar not function.
View 9 Replies View RelatedI have a aged debt report. Historically this has caused problems as when a customer paid there debt all comments were lost and we had to start from scratch if they got into debt again. Also comments had to be transfered when the data was updated.
I solved this by adding a comments sheet and a short macro that stored comments based on customer name. A lookup then showed the latest comment on the main sheet.
The main sheet looks like....
if it is possible to create a chart which only shows a portion of the data series at once, but has the ability to scroll through all of the data points using a scroll bar.
I am aware of one method which changes the input data based on formulas linked to the "cell link" feature of the scroll bar, which gets the job done. I am curious if there is an alternative method where all of the data is charted, but there is a fixed chart "window" of sorts that shows only a certain amount of the data (like a web browser - you have to scroll down to see the rest of the page). The scroll bar would ideally only reveal what is already there, rather than changing the data range via a formula. Does this make sense?
I dont know the real name about this scroll bar (like you can see in my attachment), so I cant search in the forum, sigh! how can I remove the bar in the red circle?
View 3 Replies View RelatedI have a spreadsheet with about 300 rows and columns up to AB. Is it possible to stop the page to scroll beyond the 300 rows and AB columns.
View 8 Replies View RelatedI'd like to edit this code so that I am taken to the first available open cell on a worksheet.
I have been using the following
My spreadsheet has 459 rows; however, the vertical scroll bar ends at row 569738. I have attempted to delete all of the extra rows by holding SHIFT and CTRL, striking the down arrow then right-clicking on the left margin of highlighted row numbers and choosing delete. I have also done the same procedure except clicking clear all from the editing menu. None of these methods has removed the rows and enlarged the vertical scroll bar to a proportionate size in relation to the number of rows.
View 14 Replies View Relatedget a horizontal scroll bar into a listbox ?
My litbox is 180 point wide (set by width command) but my text is wider.
I seem to remember if you set a small width in the .columnwidths property you can generate a scroll bar - but this is ignored for a single column listbox, which is what I have.
If I reset the .Width property to something very small (eg 50) then I get the scroll bar but for some reason it doesn't scroll the fullwidth of the text.
I have a spreadsheet which contains about 800 rows. Each row contains a column with the name of a different workbook. I need to scroll through each cell containing the name of a workbook and open that workbook, extract two specific cell contents from each workbook opened, and paste that information into the two cells next to the original cell containing the workbook name.
Example:
Summary Workbook column C: contains names of workbooks.
For each workbook name, I need to open the respective workbook.
Then in the first tab of the workbook I need to extract the information in E6 and K7 and copy that information back into the summary workbook in the two cell to the right of column C.
Is there a way using VBA, that I could type something in a cell, and then it would find it in the A column and scroll to it?
View 3 Replies View RelatedI'm trying to get a scroll bar to change a percentage value. My percents are to the hundredth. I understand how to adjust the properties to get it to use whole numbers... but i am trying to adjust my smallchange by .01% and large change by .1%
is this possible? or is there a workaround for it? i've only ever used scroll bars for whole numbers.
is there anyway to stop screen scroll?
so that you can only see the visible cells at opening of workbook?
I need some code to scroll the worksheet top-left.
View 2 Replies View RelatedWhat I need to do is add a scroll bar to my text box in my form. I used the properties of the text box to add a scroll bar but when you preview it you can't see it. When you click somewhere inside the form it appears and is workable but not when it hasn't been clicked on. How do I make the scroll bar appear from the start. this is a vertical one ad is on a text box within the form
View 11 Replies View RelatedOn a userform, I have 5 paragraphs of text that the user needs to read. The problem is the user can't see all 5 paragraphs, the user is only able to see about two paragraphs. I don't want to make the userform larger but I would like to add some type of scroll bar that would allow the user to scroll up and down to view all of the text.
View 7 Replies View RelatedDo any of you know if it's possible to send a scroll up / down to another app, perhaps in some fashion similar to send keys? I'm essentially pulling data from a proprietary UI into a spreadsheet where I can manipulate the data...the problem is that some of the pages have a table on the bottom half of the page with a vertical scrollbar - and I can't seem to get to the lines which are out of view.
View 4 Replies View Related
