1. M

    VBA Double Click Heading to Filter/unFilter

    Hello - I have a table labeled "Conf". When I double click on a column heading I want it to filter that column to only show rows with x's in them. When I double click again I want it to unfilter so I can do the same with another column. I appreciate your help!
  2. M

    VBA Double Click Column Heading to Filter NonBlank Cells

    Hello, I have a spreadsheet with different skills listed as column headings in the table I named "Train". I would like to be able to double click on any of the column headings and have my table filter on all non-blank cells. The rows have trainings listed so the table is full of x's that...
  3. R

    Beforedoubleclick VBA Code not completing process

    I have a vba code which works well up to a point, the code i'm using is as follows Private Sub Worksheet_BeforeDoubleclick(ByVal Target As Range, Cancel As Boolean) If Intersect(Target, Range("$L$3:$L$187")) Is Nothing Then Exit Sub Select Case Target Case "" Target =...
  4. A

    VBA Code for Entering Data With Double Clicks

    Hello All: I am trying to build a Survey Form in Excel where I want to simplify the data entry by allowing the user to enter data by double-clicking on cells (or buttons), with some areas for text input. Some questions will have multiple answer options by I want to force only one selection...
  5. R

    Double click to cell doesn´t show related cells in formula.

    F2 works OK but doubleclick not. When I do doubleclick I can edit the formula in cell but don´t see referenced cells. "Allow editing in cells" is checked in advanced options. I mean this: Don´t know how to resolve this. Thx!
  6. R

    Need help VBA code to highlight cells

    Fairly new to VBA and need some help. I have the following data in excel sheet1 in the range C2:D10. I'd like to be able to double click on either the Category or the Volume cell within the range and have that data (for the respective row) copied to another location. I have found a way to do...
  7. M

    ListBox - Need lots of help!

    I need some help with a listbox. I have gotten the very basics where I have the listbox showing up and I have the choices showing up. However, right now if I click on any of the potential options, nothing happens. What I have my code doing is looping through survey responses - then if a...
  8. Z

    VBA - Help building upon "copy & paste to new sheet cell on doubleclick" with isnumber & istext

    Hello, the code provided below is from my previous sucess (A long time ago) on this board and i'd like to ask for help again. <tbody> a 1 b 2 c 3 d 4 e 5 f 6 g 7 h 8 i 9 j 10 </tbody> Assuming the above table starts in "A1" the below vba code should...
  9. C

    When click on a column of postcodes to copy a certain value to a cell in another sheet

    Hello all professors out there. I have searched the forums but at a loss on this one. If it can be done via formulas rather than VBA great but willing to try anything at this point! I have two sheets. The first sheet contains a long list of Postcodes of our customers and I am trying to do the...
  10. B

    VBA Code in Workbook_Open Prevents Double Clicked Excel Workbooks from Opening at Startup

    I have some code I placed in the Sub Workbook_Open in an xlsm file which is placed in XLSTART folder. The code executes properly when Excel is opened. Problem. If any code is in the Sub Workbook_Open, and the user double clicks an Excel Workbook and Excel is CLOSED, the workbook will open, the...
  11. J

    Creating a Macro that double click a cell

    Hi All! I'm new here so please forgive any of the stupid things I might say :) I'm trying to create a macro that goes thru all the cells in a row, double clicks them and goes on to the next cell (all the cells already have values in them). When I record this then this is the code that is...
  12. H

    Inserting a timestamp & datestamp help. :(

    Hello, Im new to this forum and new to excel. I am trying to set up my doc. so that when i double click with in columns (B&C)) the current time get inserted in a 24hr format. I am also trying to do the same thing but with a date formula (column A, also with the double click feature) Any...
  13. A

    Can Excel Display iFrames?

    Hi Everyone! I am looking for a way to get excel to display a DFA iFrame tag on worksheet as if it were showing flash. I know that you can embed flash directly but I need a way to call in the swf from DFA, append the iFrame URL with cpq values, and have it display in the worksheet. Any idea if...
  14. ed.ayers315

    Macro DoubleClick problem

    Hi Folks I tried to put together a couple of double click events the forum users "wigi" and "p45cal" provided with a couple self modification to get what I needed. Now the problem is alone they work great but not on the same worksheet. I would like to be able to use both on the same sheet...
  15. R

    Range of Columns/Rows in DoubleClick

    Hi, I'm trying to determine if a cell in a range of cells is double clicked. The columns are B and C and the Rows are 3 to the Last Row. My code looks like this: Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim LR As Long...
  16. Jaafar Tribak


    How to make Application.DoubleClick work for worsheet cells ? It works for embeeded objects as well as for chart sheets but doesn't seem to carry the doubleclick action on cells as expected. Any ideas ? Regards.

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...