mouse

Hi, I'm using Excel 2016 64-bit and have a ComboBox with a dropdown that contains 150+ lines. I'm trying to set it up so that I can scroll through the lines with the mouse wheel.

I'm at a bit of a loss here. On every version of excel I've ever used (currently 2016) when you disable "Allow Editing Directly within Cell" you can then press F2 where the cells used in the formula will be highlighted by various colors and with the left mouse button you could move the...

Hi, I am trying to hide some rows and then freeze panes on mouse scroll. 1. User scrolls down 2. Hide rows 1-5 3. Freeze new rows 1-5 Is this possible? Sub FreezeRow() ActiveWindow.FreezePanes = False Rows("1:5").Select ActiveWindow.FreezePanes = True End Sub

Hi, I wish to write a macro that will hide (and another one that will unhide) all the comments in an Excel Sheet in a selected range (which the user selects with the mouse). I started with a simpler example with a hard-coded range (1 cell only), and it works correctly: Sub...

Hi Everyone, I put the Microsoft Date Picker in a cell and I noticed every time I open the workbook I have to work the mouse wheel to get it to activate. Is this normal and/or is there a way around that? Thank You!

Hello there, Hi Mick, Fluff and Rick ;-) I need help on a VBA code that could read a flat table and put the results in a 2D table. The 2D Tables has in rows a list of Animals that is always in the Flat Tables. (no more no less). The 2D Tables is NOT generated, it is the base where the flat...

clickclickclik! How to make a macro that would change into next sorting item with press of button? Im tired of opening filtering box , uncheckin and resizing and checking the next box with a mouse. thankyou

Hello All, I have created an user form which has a frame. The frame contains several labels. My objective is to highlight the label when mouse points to a label but highlight should disappear once mouse moves to next label and the next label should be highlighted. Following is my code...

I have loaded Excel for the nth time today and I cannot now access the VB Editor. I have the Excel and VB tabs visible. Mouse depress on the VB tab causes the active cell highlighted border to disappear and reappear when mouse released. Trust Settings are fine. I can create macros but not...

Hi, I would like to call VBA macro when mouse over on any charts available in WORD document. Please let me know if its possible and code for the same. Thanks in Advance!

Hi I want to copy a cell then paste it somewhere. After review this website https://stackoverflow.com/questions/18968856/vba-paste-range I came with the code below. My question, what does xlPasteAll means? and also can I just after copying a cell paste it into a cell that i will select with a...

I have 3 radio buttons. Each buttons has its own list in a combobox. My problem is whenever I toggle between the buttons the combobox just add the new list and keeps the old one. What am I doing wrong? Button 1 has dog, cats and mouse. Button 2 has apple, banana and mango If I click button 1...

I am using MS Excel 2013 in a new PC. In my original PC, with MS ExceI 2013, I can hover my mouse cursor on an activeX object and then click on it to run VBA code successfully . However, in this new PC, also with the same version as MS Excel 2013, whenever I hover my mouse pointer on any...

I've been watching video tutorials to learn VBA. Sometimes the user rolls his mouse over a line of code to see the result of that particular code. Like when you want to see the result of Range("A1").Offset(4,5), you hover over it and you see what the value is. I couldn't find that...

I would like to use the code RoryA posted in the thread "Code for mouse wheel in VBA" but I'm not sure what to do in order to suit my need; track the mouse wheel movements up and down in order to update a row counter I have in a cell of a sheet. Instead of a userform I have an Excel 2016 Sheet...

Hi All, If i use List Box then there is scroll bar come with List box(by default). It only work if I click by mouse on downward direction of pointer. If I scroll by mouse on that List box, it wont work..So do I have that facility on this..

hi, I have a code for getting the row numbers of selected cells (I only select cells from column A) now, If column A not filtered and I'm dragging the mouse to select several row at once, the code works. If column A is filtered and I'm choosing the cells one by one with CTRL pressed, the code...

Hello, Actually, I need a small userform to pops up after mouse over and disappearing after mouse leaves the control. Is there any way for that, or any workaround this? now I am using a userform + application.ontimecommand to close that form after 2 seconds, but this does not look good at all, I...

Hi, Is there a way to select cells mid macro with the mouse that doesn't use the input box to show what is being selected? but also wait to resume code until cell is clicked?

Hopefully, I will explain this well enough for people to understand :)I have quite a complex userform. The issue I am facing is when clicking a checkbox in a different frame it is not ticking on the first click. It takes a second click. I think the issue is there are a number of procedures that...