Free Microsoft Excel 2013 Quick Reference

Excel scrollbar

When I "scroll" using the scrollbox, the tooltip box indicates row numbers or
column letters so that I know where I am in the worksheet. I've seen most
others' scrolling causes the sheet to move along with the scrollbox, which is
much quicker and easier to view. How can I exchange my tooltip box for a
moving sheet?


Post your answer or comment

comments powered by Disqus
This code gives the correct number of Rows and Columns being used in my
worksheet:-

Dim x As Worksheet
Set x = Worksheets("Store")
Debug.Print x.Cells.Rows.End(xlDown).Row
Debug.Print x.Cells.Columns.End(xlToRight).Column

However, due to accidental over-scrolling, the displayed Excel scrollbars
represent a range of about 40 columns (instead of my sheet's correct number
of 27) and 65535 rows (instead of my sheet's correct number of 1253).

This is a major problem with Office 2007 (I don't remember it happening with
earlier versions) because when you try to import the worksheet into an Access
2007 table, you get 65535 (mostly blank) rows imported instead of 1253 and
you have to mess around identifying the blank rows and deleting them.

You also get error messages that Field28 doesn't exist, etc, if you try to
import to an existing table instead of a new one.

How do you correct Excel's internal scroll range (and/or the Access 2007
import wizard) to match "Cells.Rows.End(xlDown).Row" and
"Cells.Columns.End(xlToRight).Column"?

I have an embedded excel spreadsheet in power point. I want to manipulate cells in the embedded excel spreadsheet with scroll bars in powerpoint. The red scrollbar appears to work fine (it changes number in red cell), but the green scroll bar (changes number in green cell) is not working properly.

Try moving the green scroll bar a few times after you have moved the red scroll bar. File is attached.

Could someone suggest what is wrong with the code?

Thanks in advance for your help

G'day,
I am new to VB programming but have used copied VB scripts and the GUI to program Dbase objects in Access since v2. I am now trying to create a form for a friend in EXCEL 2003 that allows them to browse/edit their rows of addressbook/contact data from the spreadsheet. She wants a form much like the basic form included in Excel under the 'Data' and 'Form' menu option - but with the flexibility to adjust the width and location on the form of the fields and their sizes. I can build the basic form in VB Editor but cannot see how to sync the bound listbox or combo boxe controlsource to a scrollbar 'value' property so the user can click up/down to go to the next/previous row (record). Cheers, Ken

Is it possible to create a second vertical scrollbar in an excel spreadsheet?
Not a split or a freeze, but so that I could have two sets of data happening
at once.

Hello!

I have a need to insert to scrollbar inside an existing Excel tab due
to a huge amount of column..
I know how to insert the scrollbar but I don't have any clue as to
make it so it'll scroll left/right. For instance, column A - D will be
stagnate because I need them for headers and title. I would like
column E-IV to scroll left or right based on the embeded scrollbar. I
know I can do a freeze pane but I don't like the look of the splitting
line as I already have a horizontal split already.

Any thoughts will be appreciated.

Lee

Hello all,

I was able to embed a scrollbar into an Excel worksheet. I would like
to protect this worksheet and only allow certain cells to be modify. I
know how to do that BUT, every time I protect the sheet, it also locks
the embeded scrollbar so that I can't slide it anymore. Any thoughts,
comments, suggestion?

Lee

I have a excel spreadsheet embedded in a powerpoint presentation. I want to use scrollbars in powerpoint to manipulate cells in the embedded excel spreadsheet. One of them (red color scrollbar) works, but the other one (green color) does not work properly. Try moving the green scroll bar a few times after you move the red scrollbar to see the problem.

Any clues to where the problem lies?

Please see attached file. Thanks in advance for ur help.

HI,

I have attached a template of Gantt chart in excel. Now there is a scroll bar at the top which shows chart for roughly one year. I need to able to view the same for about 2 years. In simple terms i have to take a print out of the entire chart so is there some way by which i can edit the scrollbar so that the view area under it is increased or it is removed altogether.

I have wasted a lot of time figuring it out but all in vain..

Can S'one help please.

regards,
Andy

In Excel 2000 I have a number of spreadsheets open with 3 or 4 columns of
data containing 30 to 1000 rows each. As I, edit, cut and past within and
from document to document, the bottom scrollbar has is below the screen
making it inaccessable and the right scrollbar's down control out of view.
Other than using the Pagedown/Pageup keyboard keys, is there a way to restore
the scrollbars to view different parts of my spreadsheets? I have tried
resizing the window in a variety of ways with no luck.

I am using Excel VB control tool -- Scrollbar, and instead of having an
integer on the min and max, I want to use decimal number. It seems to me the
scrollbar only accepts whole number. Can I use decimal number in scrollbar? I
want to have a minimum of 0 and max of 3.0, and an increment of 0.1 as I
scroll the horizontal bar.

I need help!!! I need to insert a scrollbar in a cell in one cell in Excel.

Thank you

nick

I have used the following vba codes to hide the menu bars, toolbars, etc. on Excel 2003 'Main Menu Sheet', and it has worked perfectly well: I'm sorry I tried many times to enclose the code using the # tag, but it would come out wrong hence I have pasted it without enclosing it.


	VB:
	
) 
    Dim ws As Worksheet 
    If ActiveSheet.Name = "MAIN MENU" Then 
        Application.CommandBars("Worksheet Menu Bar").Enabled = False 
        Application.CommandBars("Standard").Visible = False 
        Application.CommandBars("Formatting").Visible = False 
        With ActiveWindow 
            .DisplayHorizontalScrollBar = False 
            .DisplayVerticalScrollBar = False 
        End With 
        Application.DisplayFormulaBar = False 
        Application.DisplayStatusBar = False 
    Else 
        Application.CommandBars("Worksheet Menu Bar").Enabled = True 
        Application.CommandBars("Standard").Visible = True 
        Application.CommandBars("Formatting").Visible = True 
        With ActiveWindow 
            .DisplayHorizontalScrollBar = True 
            .DisplayVerticalScrollBar = True 
        End With 
        Application.DisplayFormulaBar = True 
        Application.DisplayStatusBar = True 
    End If 
     
    Application.DisplayAlerts = True 
End Sub 
 
Private Sub Workbook_BeforeClose(Cancel As Boolean) 
    If Sheets("MAIN MENU").Range("A1").Value = "close" Then 
        Sheets("MAIN MENU").Range("A1").Value = "" 
        Application.CommandBars("Worksheet Menu Bar").Enabled = True 
        Application.CommandBars("Standard").Visible = True 
        Application.CommandBars("Formatting").Visible = True 
        With ActiveWindow 
            .DisplayHorizontalScrollBar = True 
            .DisplayVerticalScrollBar = True 
        End With 
        Application.DisplayFormulaBar = True 
        Application.DisplayStatusBar = True 
        ActiveWorkbook.Saved = True 
        ActiveWorkbook.Close 
    Else 
        Application.CommandBars("Worksheet Menu Bar").Enabled = True 
        Application.CommandBars("Standard").Visible = True 
        Application.CommandBars("Formatting").Visible = True 
        With ActiveWindow 
            .DisplayHorizontalScrollBar = True 
            .DisplayVerticalScrollBar = True 
        End With 
        Application.DisplayFormulaBar = True 
        Application.DisplayStatusBar = True 
        ActiveWorkbook.Save 
        ActiveWorkbook.Close 
    End If 
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
However my PC which has Office 2003 developed a serious fault and on transferring to another PC with Office 2010, these same codes which successfully hides the menu bars, toolbars, formatting bars, etc. for the 'Main Menu' sheet (Excel 2003) is not hiding the menu bars, etc. for the same Main Menu sheet for the Excel 2010.

The 'Main Menu' sheet contains only command buttons that enable me to go to other sheets in the workbook. It also includes a command button to 'Exit Application'. The other sheets contain command buttons that enable a user to get back to the 'Main Menu' sheet. It is therefore only the 'Main Menu' sheet that I do not want the menu bars, formatting, scrollbars to be visible. This has worked well with Excel 2003 in my now-faulty PC.

I should be grateful, please, for any adjustment to the codes so I can achieve the same aim in respect of the 'Main Menu' sheet with Excel 2010. I want to prevent users from attempting to format or alter the 'Main Menu' sheet.

Thanks for your help.

Buddy

Hi

I'm using Excel from Office 2000.

I have a workbook in which the sheet tabs and horizontal scrollbar have disappeared. I can only access one of the worksheets, there are 8.

Is it possible to access worksheets from keyboard without using the sheet tabs?

The vertical scrollbar is partially working. The up arrow is visible and I can use it to scroll up the file. The verticle slide bar will move up and down the visible page. The down arrow is missing and I cannot scroll below the visible page. However I can go down the file by hitting the enter or down arrow keys of the keyboard.

I have gone to Tools-> Options-> View tab and unchecked Horizontal scrollbar and Sheet tabs hit "OK" and returned to check these items and reapply them.

In windows I readjusted the scrollbar size. These changes were reflected in the portion of the verticle scrollbar that was visible.

My other workbooks have working sheet tabs and horizontal scrollbars.

R7sal

hi

i would like to know how can we apply win xp styles to buttons and scrollbars in EXcel VBA

Hi
I have scrollbar control on excel sheet, I want to make maximum value of this control to be linked to a cell on the sheet. So, when the cell value changes, the scrollbar maximum changes automatically with this value.

Thanks for Help
Regards

Hi,

I have just encountered a very peculiar problem when using Scrollbar_Change Event for Controls Scrollbar (in a worksheet). I have tree scrollbars and assigned Event code for each one: ScrollBar1_Change, ScrollBar2_Change and ScrollBar3_Change.

Events works perfectly when I click on the arrows to adjust the scrollbar. What is strage however, event is not executed when I adjust the scrollbar itself (pulling the bar with a mouse) if I try it first time after adjusting another scrollbar. In such situation Scrollbar is adjusted on the screen, even linked cell is changed, but the Change Event is not executed. But when the same scrollbar is adjusted second time Change event is executed.

To sum up: Scrollbar_Change event is not executed when adjusting the scrollbar with the mouse the first time after "switching" from one scrollbar to another, but is works perfectly in any other situation. It has nothing to do with the code istelf. I get this effect when I create a new workbookm add 3 scrollbars and a code like:


	VB:
	
 ScrollBar1_Change() 
    MsgBox "ScrollBar1 changed!" 
End Sub 
 
Private Sub ScrollBar2_Change() 
    MsgBox "ScrollBar2 changed!" 
End Sub 
 
Private Sub ScrollBar3_Change() 
    MsgBox "ScrollBar3 changed!" 
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
What may be the cause of this selective "disobedience"? Note also, that I get this error on Excel 2000 (not tested it on Excel XP or 2003).

I have searched (briefly) in vain...

I must be missing something simple - I'm playing around with listboxes for the first time and I can't work out how to prevent a horizontal scrollbar appearing in the event that Excel decides the text is too wide...

The data I am populating my test listbox with is only a few characters long, but Excel seems to demand that the listbox be approximately 2.5 times the width of the text before it will stop forcing a scrollbar on me.

Any ideas?

Hello

I have built a questionairre in excel and some of the wording(text) exceeds the space available, I would like to place the text into a 'frame' eg 5cmX5cm with a scrollbar so that the user may scroll through the text. Also, from an aesthetics point of view this would look a lot neater.

I am not sure if this is possible, however would appreciate and advice or help.

regards

mo

I have run into a problem with Excel that no one seems to be able to answer. I even took a class and the instructor, who was very good, could not really help. When I open a certain worksheet, sometimes my scrollbars are there, and sometimes they are not. I have tried the help option ' Detect and Repair' and that has not helped the problem. In this particular worksheet the scrollbars are used a lot, so would like them to appear all the time. Anyone got any ideas as to why this would happen? I gave my personal addy, but this is a problem at work, and the addy for work is: cclark@j-quin.com

Thanks in advance.
Cathy Clark

Hi and thanks in advance! Am in desperate need of advice

I have scrollbars on a userform created in Excel 2003 VBA because the form is v long and I want to be able to scroll to the bottom.

However... the scrollbars run along the length of the form and not - the way it appears on this webpage for instance - just on the visible part of the page.

If the scrollbars run along the length of the form it makes it almost impossible to use.

Does anyone know how to make the scrollbar appear in the way I want i.e. shorter than the form??

Thanks 1,000,000

I have an excel spreadsheet in which I want to create a scrollbar bound to 3 different cells. Cell A1 would include a scrollbar with a list of all the unions (local 7, local 2058, etc). Cell B1 would include turnaround time for disciplinary hearings (10 days, 5 days, etc). Cell C1 would include turnaround time for grievance hearings ( 7 days, 5 days, etc). Cell B1 and C1 will be dependent on A1. In other words, when I choose the union I want the disciplinary and greivance turnaround time to be populated in cells B1 and C1. Is this possible using "IF" statements or VBA syntax? By the way I am using Excel 2003. Any help would be greatly appreciated!

Hi All

I have an Excel graph, which i have a scrollbar for. This can scroll through the 6 months at a time. I need a way of copying the graph into a power point slide so that the scroll bar still works

Any suggestions???

Hi all,

I've lasted quite a while since I last had to ask questions, and I've been doing quite well on the VBA etc... however, I've now hit a bit of a wall with what will probably be quite an easy task!

I want to put a text box (or a label) on to an excel sheet, which will have a range of data in it to assist a user in how to use the functions within the spreadsheet.... I want this to be a smallish box, with a scrollbar on it... basically so that it doesn't take up to much space...

Can anyone advise how I can merge the text box/label and the scrollbar so that the scrollbar controls where the label is at?! does that make sense?

(take for example the "quick reply" area on a forum, which has a certain amount of space for you to read the information, and then there is a scrollbar so that you can go back through it to whichever height you need... )

Thanks in advance,

Jonathon

Hi, this is my first post to this forum but I've been really helped by the tips I've read from others in the past. Unfortunately these have taken me into areas I'm unfamiliar with, and so I'd really appreciate some help.

Having learnt how to use Forms to give the user the ability to select an item from a List Box, I got frustrated because I couldn't change the default font size (I'm designing a large file that is to be used on several machines with different screen resolutions, and shrinking the sheet magnification down makes it very difficult to select an item).

So I discovered the Control Toolbox and painstakingly swapped all my Form toolbar List Boxes over to Control toolbar List Boxes.

Two major problems resulted however. Firstly, I can't find any way to change the colour of individual items in the list. In one of my forms I have over a hundred items in the list, just one of which must be selected by the user, and I'd like individual items in the list to be one of a few different colours to make them easier to identify. Can this not be done? If not, how else can you suggest I could make certain items in the list stand out?

Most annoyingly, every time I move the mouse scroll wheel in a worksheet which contains a Toolbox-generated Form (usually just accidentally, it's easily done), Excel promptly crashes. It's fine if I use the scrollbar in worksheets that don't contain forms, or that contain forms that I created using the Forms toolbar however.

Apparently I'm not the first to find this, but is it a known bug in Excel (I found the behaviour described at http://www.microsoft.com/communities...el.programming ) I've taken mouse graphics acceleration or whatever it's called right off in case it was causing the problem, but without success.

I'd really appreciate suggestions for overcoming these problems - I thought the Toolbox type of forms were meant to be what you should use for user selections, and that the Forms toolbar was just a legacy. But if I can't get Control toolbox forms to work without crashing, what is the point of them, I'd be better off just sticking to using Forms, except they don't work properly except at 100% magnification.

Incidentally, I've no idea how to go about programming in VBA, so I hope you don't mind going easy with me if you tell me I need to start playing with Visual Basic codes, I'm a medical doctor not a computer programmer! For the record I'm running Excel 2003 as part of Office 2003 Professional on a Windows XP Professional Lenovo Thinkpad T60. Thanks in advance!


No luck finding an answer? You could always try Google.