1. A

    DoubleClick macro not working at all

    I have a simple Double Click macro that works elsewhere but in this particular workbook nothing happens. I double click into the cell and it just goes to edit mode, no macro runs. EnableEvents is True and the only other thing I can think of is it has something to do with both sheets being SQL...
  2. J

    inserting pictures through vba, but the position and range doesn't match

    Hi, i made a macro by clicking the cell and inserting a picture image. But, the vba range and the sheet range doesn't match. ex. i want to insert a picture in cell b6 but it seems the picture inserts in between b5 and b6. this is my code below Private Sub Worksheet_BeforeDoubleClick(ByVal...
  3. 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!
  4. 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...
  5. 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 =...
  6. 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...
  7. 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!
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back