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


ADVERTISEMENT

Scroll With Wheel Mouse In ListBox?

Sep 16, 2012

Scroll with Wheel Mouse in ListBox?

View 1 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

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

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

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

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

VBA Causing Excel To Crash?

Apr 15, 2014

I have a piece of code in one of my Macro's, if I run the macro and don't let this piece of code run everything works fine, when I let this piece of code execute the excel file keeps running until I go to save, at which point I get a message saying "Microsoft office excel has encountered a problem and needs to close. We are sorry for any inconvenience".

Code is as follows:

If MsgBox("Copy and hardcode this scenario?", vbYesNo) = vbYes Then
Calculate
Application.DisplayAlerts = False

[Code]....

View 3 Replies View Related

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 View Related

ClearContent Macro Causing Excel Crash?

Feb 22, 2014

Have a code to clear contents on one of my worksheets and it continually causes excel to freeze and forces me to exit the program. When the button is selected it takes approx. 30-45 seconds to clear the data and then excel freezes up. The code is as follows:

Sub()
Sheets("Sheet1").Range("B2:D16000").ClearContents
End Sub

The data in the range B2:D16000 comes from another macro that copies and pastes values to this sheet. I am also working on the mac 2011 version.

View 5 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

Custom Sort Macro Causing Excel To Crash?

Jul 10, 2012

I am trying to sort a bunch of data by a custom list from left to right and after running the macro successfully excel crashes upon saving. I have tried this on different computers, resaved, started from scratch and it always crashes so there must be something with the macro that is causing this.

here is my macro:

Edit: It seems that the last line of code is causing my problem. I have started from scratch and gone though all the code one at a time and saved after each run. everything is fine until the "Application.DeleteCustomList Application.CustomListCount" is run. after that excel crashes when saved.

VB:
Sub Macro3()
'
' Macro3 Macro
'

[Code]....

View 1 Replies View Related

Object Invoked Error Causing Excel To Crash

Jul 14, 2014

I am receiving the following error:

-2147417848 automation error the object invoked has disconnected from its clients

Unfortunately, I can't tell where the error is occurring because everytime it happens excel crashes or at least stops responding. I tried waiting it out (about 20 minutes) but no luck. the only thing I can do is force the program to shut down through the task manager.

The program is designed to pull information from finviz.com (a financial site), filter the data. pull the next round of data and run the filters again. there are a total of 8 queries and i think it gets hung up during the 6th or 7th run through.

Stepping through the code does not seem practical since each query might pull as many as 300 rows of data that is evaluated in a for/next loop (thats a lot of F8s).

View 5 Replies View Related

Mouse Scroll Not Available After Pressing F2

May 15, 2008

I recently upgraded to Excel 2007. I use Excel with "Allow editing directly in cells" unchecked. In previous versions, pressing F2 would not prevent me from using the mouse scroll, but in Excel 2007 I am unable to mouse scroll which makes it bothersome. Is there a setting somewhere that can enable mouse scroll after pressing F2?

this is a work product and we can't use VBA.

View 3 Replies View Related

Mouse Scroll WITHIN A Data Validation List &amp; Option Macro Assistance

Jan 7, 2010

I'm trying to do a few things actually. I am somewhat a newb at programming, although I do understand how C++ and the coding works within Excel. To me, it's like the English language...knowing all of the vocabulary and formatting it right is important. If I don't know the vocabulary, I don't know what options I have.

This tool is being used in the call center I work in. It is to help eliminate repititious information used to notate accounts. I have attached a picture of what the tool looks like so you can have a better idea of what I'm working with. Here are a list of things I'm trying to do which I have searched and not found answers to:

1. I am trying to use a middle mouse scroll to scroll through validation list. This list information is located on a different locked tab. Basically, I have a few rows where a drop down selection can be made and it would be easier to scroll rather than manually moving the slider within the validation list.

2. As you can see, this "tool" an employee and I have created has many buttons. What I would like to do is to be able to click a button on the right and have it "stack" text within a single cell. In other words, if I click the button once, the text may be entered into the "actions taken" cell. If I click another button, I can have the option (or maybe a little "+" next to the button) to add this button's information to the end of the information already entered within the "actions taken" box. I've tried recording and using the keyboard and selecting "end" and then having the text added, but it didn't work. I've seen "loop" VBA code, but I don't want something to repeat, I want it to stack in the cell when clicked manually.

I'm sure there is a way to make the tool much better using VBA code and not use Excel, but I don't have an extensive knowledge of Excel to do something like that. I'm a very fast learner and understand how the coding works, so if you have an idea which may help, and you understand what I'm trying to do here, please provide your .02.

Basically, it's used so the Customer's name and phone number are entered manually, and then just about everything else is automated by the use of the buttons on the right. If I could get the 2 above options to work, it'd be perfect. I just figured out I could eliminate screen flicker and hide the macros working by using:

View 12 Replies View Related

Disable Middle-mouse-click Scroll On Inherited Excel File

May 7, 2014

I've just inherited a load of Excel files I need to continue using, but my predecessor has done something that disables the middle-click scroll ability.

I can still scroll up and down by turning the wheel, but I want to be able to click it and scroll in all directions at speed - I didn't realise how much I used this until I couldn't. Can't see anything in the VBA sheet properties, and they are all .xlsx files. Nothing leaps out of the settings either. If I create a new file or a file of mine within the same session, they work fine.

View 1 Replies View Related

Limit Scroll Area - Code Activates Only On Mouse Or Keyboard Input

Apr 21, 2007

I have a worksheet that serves as a navigation page for the workbook and use the following code to restrict from scrolling off the viewable content. The problem is that the code doesn't kick in until either a click if the mouse or keyboard input. This initially leaves the worksheet open for scrolling until input is received.

How do I make this code activate when the wb is loaded? Code in the Thisworkbook module already makes the menu the visible sheet, and code limiting the scroll area is in the sheet module.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
With ActiveSheet
.ScrollArea = "A1:L11"
End With
Range("A1").Activate
End Sub

I've also tried using "Range("A1").Select", but it doesn't work either. How can I get this to work correctly?

View 2 Replies View Related

Listbox Control Source Causing Error

Oct 26, 2008

why this is causing an error upon opening the file. This workbook has a userform with a listbox (single list, single selection), and when I have the ControlSource property set it causes an error upon opening the userform (which opens when the file is opened), whereas if I do not have the ControlSource property set to anything, it seems to work fine.

Interestingly, if I set the file up to not open the userform with the file, and instead have the userform open when a worksheet control such as a command button is clicked, it doesn't seem to matter if the ControlSource property is set or not. The workbook in question is attached.

View 14 Replies View Related

Mouse Hover In A ListBox

May 19, 2009

I have a Listbox with multiple items (Multiselect property is on). However, due to the length of the items not all the parts of it is visible within the listbox.

Is there a way by which if a user hovers the mouse over an item in the ListBox (or selects an item), the whole item is visible (the way it is done in ControlTipText)

View 13 Replies View Related

Listbox Pop Up Menu On Mouse Right Click

Feb 12, 2007

I have a list box with items. When I stay on item and press mouse right click, I want see pop up menu with "remove this item" and "add new item".

View 8 Replies View Related

Getting Horizontal Scroll Bar In Listbox?

Mar 3, 2006

get 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.

View 2 Replies View Related

Controlling Scroll From One Listbox To Another

Nov 18, 2013

I have 2 list boxes and want to controll scrool range (View) depending of selection of List Box 2.

Here is my code.

Private Sub UserForm_Initialize()

'ListBox1
Dim lbtarget As MSForms.ListBox
Dim rngSource As Range
Dim arr
Dim I As Long
Set rngSource = Worksheets("Material").Range("F4:K3000")

[Code] ..........

View 8 Replies View Related

Selection Of Rows In A Listbox From Program, Not With The Mouse

Jun 24, 2006

I have two files and I need to compare them. The two files will be store in a listbox an I have to make the lines that are different with another color or select them so it will be easy to see the diferences. It is for one project that have to be ready tomorrow

View 8 Replies View Related

Crash After Worksheet Calculate?

Apr 14, 2014

The situation is a Workbook_Activate macro is conflicting with a worksheet module which is a worksheet_calculate that also runs a macro when there is a query refresh from another book. How do I get the workbook activate macro to run before the worksheet one activates? Right now everything crashes.

View 1 Replies View Related

Control Scroll Bars: Remove The Scroll Bars From Just One Worksheet But When Unticked

Jan 13, 2007

In 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 Related

Mouse Click Selects Wrong Listbox Item

Oct 2, 2013

A list box selection works fine on my computer but on a friends Windows Vista PC the following happens:

Selecting items near the top of the list works fine. 1/4 of way down a mouse click on an item selects the Next item.
1/2 of the way down in the list, the mouse click on an item selects the one 2 or 3 further down, etc., etc.

View 1 Replies View Related

Excel 2010 :: How To Remove Horizontal Scroll Bar From Listbox

Feb 10, 2012

Using Excel 10, Win 7, a User Form with list box control, I only need one column about 7 characters long. (At this point my horizontal scroll bar is taking up more room than the list box window so I'd really like to lose it). I don't see any property options for scroll bars to set.

View 2 Replies View Related

Prevent Worksheet Change Event Causing Chain Reaction

Jan 14, 2008

I'd like the users to be able to change some detail in a couple of places and have it updated throughout the spreadsheet. Basically, the user can change the line name in any of the input sheets and the code changes the sheet name, and searches for the reference to the old name in the overview sheet and changes it accordingly.

The problem I have at the moment is that I would also like the user to be able to change the line name from the overview sheet too... I am having trouble thinking how to have similar code in the "Overview" sheets Worksheet_Change event without getting into a big constant loop... e.g. if the line name is changed via code on the individual input sheets won't that then trigger the first code, which will trigger the second etc. etc. I have the following code in the ThisWorkbook section:

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Dim sName As String
Dim sOldName As String
Application. ScreenUpdating = False
sOldName = ActiveSheet.Name
If Target.Address <> "$B$1" Then Exit Sub
sName = ActiveSheet.Range("B1")
On Error Goto ErrorHandler
ActiveSheet.Name = sName
On Error Goto 0
Sheet8.Select 'this is the overview sheet
Cells. Find(What:=sOldName, LookIn:=xlValues, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate........................

View 2 Replies View Related

Worksheet Datatable Won't Scroll

May 18, 2011

I have a datatable with data from 2010 and 2011. The worksheet will not scroll at all. It looks like it is scrolling at the side where the scroll bar is but the worksheet does not move. I can move the tab up or down but the page/worksheet doesn't move at all. If I activate the filter and select only the year 2011 in the drop down box for the Date column, it scrolls fine. But if I check "All Dates" or just "2010" from the drop down box on the Date column the page/worksheet will not scroll. I can select a certain month from the drop down box for 2010 and it will show the data (about 25 rows) but I cannot scroll. When I have just 2011 selected from the filter it all works fine. I'm not real swift with Excel. It was working fine until today.

View 3 Replies View Related

Get Out Of Textbox And Back Into Worksheet Cells Without Using Mouse?

Oct 1, 2011

how to get out of a textbox and back into the worksheet cells without using your mouse?

View 7 Replies View Related







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