ComboBox Scrolling With Mouse Wheel

Aug 29, 2006

Is there a way to scroll down the list of entries in a combobox using the mouse wheel instead of clicking on the box to scroll up and down?

View 2 Replies


ADVERTISEMENT

Mouse Wheel Scroll In A Combobox On Userform (Lots Of Code)

Sep 16, 2007

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.

View 9 Replies View Related

Worksheet Scrolling With Scroll Wheel Is Broken

Oct 22, 2008

I have a workbook with 8 sheets, one of which is the "main" sheet that holds all of my user data for logins at my job (I'm in IT). There are about 4300 users and 23 fields for each user, so there are 4300 rows in the sheet. Other sheets in the book are important, but not as much as this one.

The workbook has a total of over 1000 lines of VBA code right now, as I'm building a tool that finds users, adds users, modifies users, etc. (I know, Access would be smarter for this, but for some reason they want me to use an xls). Most of this code works with the sheet that I'm having the problem on.

This ONE sheet has seemed to disable the functionality of the scroll wheel, and I can't use Page Up or Page Down while in the sheet either. Also, if I select cells with VBA (Sheet2.Range(<range>).Select), it will select the cell, but it will not draw focus to that cell on screen (the sheet will not move at all). The other 7 sheets in the workbook have all regular functionality.

This just started happening a couple days ago, and I've been building the code for about a week, so I'm wondering if it's something in the code...?

Does anyone have any idea what might cause this?

View 14 Replies View Related

Mouse Scroll Wheel In VBA

Jul 29, 2005

how to enable the mouse scroll wheel in VBA?

I'm talking about the little wheel in the middle of the two mouse buttons, the one that you can use to scroll up and down through documents etc.

View 8 Replies View Related

Scroll With Wheel Mouse In ListBox?

Sep 16, 2012

Scroll with Wheel Mouse in ListBox?

View 1 Replies View Related

How To Make Scroll Sideways With A Mouse Wheel

Jul 18, 2008

How can i make my mouse wheel scroll an excel sheet sideways instead of up and down?

my sheets are only 5 rows big, but some 20 columns and its a pain to move around the sheet efficiently!

View 9 Replies View Related

Excel 2013 :: Disable Ctrl+Mouse Wheel?

Apr 8, 2014

Is there any method to disable Ctrl + mouse wheel function in excel 2013, actually I want to disable zoom in and out functionality but don't want to disable normal scrolling.

View 2 Replies View Related

Worksheet Listbox Causing Crash With Mouse Wheel Scroll

Aug 21, 2008

I am having problems with an Excel workbook I am working on. I have a sheet that has a number of controls added to the top of it. Two of these controls are listboxes. My problem is, if I am in the listbox navigating through it, and I accidently move the Mouse Wheel, Excel crashes and I get the usual, "Send Error Report" form.

I have seen that there are other people having this problem and that there are a number of solutions out there but my problem is a bit different. I have a few forms with listboxes on them, and while mouse wheel scrolling doesn't work, it certainly doesn't crash Excel. It only seems to happen when I have a control permanently added to the sheet. Is there any event handler for mouse wheel scrolls or anyway to disable them through VB?

View 2 Replies View Related

Excel 2007 :: Mouse Wheel Scroll Function Doesn't Work

Feb 8, 2012

I'm using Excel 2007. When I try to scroll with the mouse wheel, it doesn't do anything. If I hold down the control key and scroll with the mouse, it zooms in and out. So that works fine, but I can't do the basic scrolling up and down the document with the mouse wheel. There is no "Tools, Options" menu in 2007 so I don't even know where to find this type of option. The options available from the Office button are completely different.

View 4 Replies View Related

Close Combobox List On Mouse Exit

Oct 28, 2009

On a userform I am using the MouseMove event to dropdown a combobox list. When I move the mouse away from the combobox the list remains dropped down. I want the list to close when the mouse moves away as it hides other controls on the form.
I have tried using MouseMove when over the userform or transparent labels around the combobox to set focus to other controls but this does not close the combobox list. The only way to close the list is to click away from the combobox. I have looked at how to simulate a mouse click but that is beyond my limited understanding of vba. If this is the only way to achieve the required result then I need some patient assistance. I am using Excel 2000 on XP.

View 4 Replies View Related

Roulette Wheel Sequencing

Jun 1, 2014

I do not have any information about exel but there is an urgent need to program.The numbers on a roulette wheel automatically want to calculate the distance between. There are 37 numbers on the roulette wheel and Sequences matter of form

0 26 3 35 12 28 7 29 18 22 9 31 14 20 1 33 16 24 5 10 23 8 30 11 36 13 27 6 34 17 25 2 21 4 19 15 32 0

[code]....

View 14 Replies View Related

Definable Scrolling

Nov 30, 2008

I've created a worksheet with split panes. I'm able to scroll through my data vertically and horizontally while keeping one area of th screen stationary. Here's my question:

Is there a way to limit the movement of my scroll bars so that it can't move beyond the viewable portion of my worksheet? In other words, I want the scrolling to end when there is nothing else to see but a field of empty cells.

View 11 Replies View Related

Scrolling Of Several Windows

Nov 6, 2007

way of getting two sheets to scroll together, so when I scroll one window the other one moves too? Some text editors have that future (IIRC UltraEdit does)

I can't find a scroll event in the windows code to trigger a macro to run itself.

I can get around it by using a selection change event which would restrict me to moving around with the cursor keys/Pageup/down, but I've got 15,000 to review regularly in a short space of time and it would be quicker by mouse

View 9 Replies View Related

Scrolling To Next Blank Row

Mar 18, 2008

[code/]Private Sub Worksheet_SelectionChange(ByVal Target As Range)

'This macro scrolls the Report to TopLeft when you click
'anywhere in the Report columns

If Target.Column > 16 And Target.Column < 22 Then
With ActiveWindow
.ScrollRow = 1
.ScrollColumn = 15
End With
End If

If Target.Column >= 1 And Target.Column < 15 Then
With ActiveWindow
.ScrollRow = 1
.ScrollColumn = 1
End With

End If
End Sub[code/]

...but I cant figure out how to scroll it down the list to the NextBlankRow-20 such that the previous 20 lines of data are shown to the top of the screen.

View 9 Replies View Related

Scrolling :: Only The Used Range + 1

Jul 14, 2008

Is it possible to use a macro that do the following:

scrolling, only the used range + 1

So if the used range is B2:D12 then the scrolling is possible to row 13 and column E

View 9 Replies View Related

Scrolling To The Right - Skip Every Fifth Column?

Apr 26, 2014

I want to return the value of E2 from sheet, "ALL INFO" and paste it in B2 on my current sheet. When I scroll this formula to right, I want the next to be the value of J2 from sheet, "ALL INFO," etc.

View 2 Replies View Related

Fix Sum Cells To Always Be In View? Even When Scrolling

Feb 10, 2009

Ive seen on someone elses workbook the first 6 columns are fixed (always in view) then you can still scroll across but those first six columns always stay in view.

View 3 Replies View Related

Disabling Scrolling In 2007

Dec 18, 2009

I'm looking to disable the horizontal and vertical scrolling in 1 worksheet

Am i able to do this?

View 5 Replies View Related

Horizontal Scrolling Loop

Feb 2, 2014

I'm having a problem working with a protected document made by another user.

The sheet has a vertical split at column F, and when I use the arrow keys to scroll right beyond this line (ie from column G and beyond), when I reach the last column (BB), it just loops straight back to the beginning (column F). This also happens in the same direction.

How I can stop this happening, so that it just stops when it reaches the end of the document?

There doesn't appear to be any coding on the sheet.

View 1 Replies View Related

Scrolling Bar Within A Cell For Text

Jul 5, 2014

I have a spreadsheet where I want to put notes in, but I don't want to re-size the cell as it will ruin the format. The amount of information will vary from entry to entry, each entry into the sheet will have its own row and within that entry I want to dedicate one column's cell for that entry's notes. Is there anyway to make a macro for a scroll bar for individual cells so I can scroll though the text entered in that cell. I have tried a text box but the text overflows once the amount of text over fills the text box.

View 4 Replies View Related

Mousewheel-Scrolling In UserForm

Nov 17, 2009

i want to know whether there is any way to make an MouseWheel-Event in VBA (Excel 2003) and send it to the scrollBars of my UserForm?

View 3 Replies View Related

Scrolling In Userforms Without Scrollbars

Feb 1, 2010

I want is a form that has three different partsof it. Each part containing checkboxes, a spreadsheet, textboxes and labels. But I only want to display one of these parts at a time, depending on what the user clicks.
I know I could write code to move everything into the visible part of the form but that would be messy. I hoped I could find some way to instead move the visible part. Like if I had scrolled.

An example. Say the visible form is 100 high and 100 wide. When opening you see from the width 0-100 and height 0-100 (pixels or whatever those things sould be called). Upon pressing a button I instead want to see width 101-201 and height 101-201.

View 5 Replies View Related

Selecting Cell And Scrolling Up?

Dec 1, 2011

I am sure this has been asked -and answered- before.

I need to select a cell, e.g. C1000, and change the view, so that I see C1000 on top of my spreadsheet.

range("C1000").select clearly does not accomplish what I want.

View 4 Replies View Related

VBA Code To Disable Scrolling Up Or Down

Dec 30, 2011

What is the vba code to disable scrolling Up or down?

View 1 Replies View Related

Limit Scrolling In Spreadsheet

Nov 9, 2012

Is there a way to limit the number of columns and rows that a user will see and therefore limit the scrolling in a spreadsheet?

View 6 Replies View Related

Automatically Scrolling A Worksheet?

Jul 28, 2013

I have a worksheet with a column("A:A") of about 1000names. The user will start at the top and work down, entering stuff into other columns for some ofthe names. My need is: How do you automatically scroll, with code, say row 48to the top of the worksheet when the user reaches row 48 with?.

View 2 Replies View Related

Scrolling Area Code

May 29, 2008

I have a sheet in which I want to limit the scrolling area to B2:B60 & D2:H60, in other words I don't want to include neither A2:A60 nor C2:C60 in my scrolling area.

Is there a way to do this?

I know I can lock the cells, however, pre-existing code will not work if cells are locked.

View 9 Replies View Related

Trap Worksheet Scrolling

Sep 17, 2008

When the user scrolls the worksheet (using a scroll wheel, or the scroll bars) I would like to have a VBA-code triggered, but in Excel 2003 there is no "VBA-event" for scrolling...

Is there any way of trapping that a scroll has happened, even if the selection didn't change?

View 9 Replies View Related

Scrolling Charts Two Lines

Oct 28, 2006

I have adapted Andy Pope's scrolling chart and have done some searching here on how to adapt this chart to plot at least two lines. For example, have sales data for the months of 2005 on one line and sales data for the months of 2006 on the other line so that corresponding months move together. I read a previous thread suggesting to change the source data to include the new data however I get a reference error message. I have attached the example that I am currently working on

View 4 Replies View Related

Prevent Worksheet Scrolling

Oct 19, 2007

I have an excel sheet embedded in a Powerpoint presentation, but I have the problem that users are editing the sheet and accidently or unknowingly scrolling around. This results in the window resizing itself when the exit the object and messing up the appearance of the presentation. Is there a way of easily preventing scrolling (either via VBA or other)? I can obviously hide the scroll bars but that does not prevent the use of the mouse's scroll-wheel. I have also already hidden all unused columns and rows so that they cannot oversize the window.

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved