double click

  1. M

    Double click for changing cell color

    I have this VBA (see below) to change the cell color on a double click. I need to make this so it will change a row of cells with the double click. Any ideas? Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Cancel = True Select Case Target.Interior.ColorIndex...
  2. J

    Update worksheet cell value and Listbox rowsource with double click in another Listbox

    Hey guys! I'm working on a project that includes an User Form that should incorporate the following functionalities: a) User searches a database by typing a value in a textbox b) Once clicking "Search", the results are display in a Listbox c) If an item in the Listbox is double clicked, the...
  3. E

    Capture and display the cell number being double click as a History record

    Hi All expert, Can I check with you.. As I have a Tools booking system. However, notice, people book already and then unbook later. So I want to track who double click the cell to unbook. How? I intend to record down the action that the user did in the form. Now I can record down the user name...
  4. S

    Double Click Problem with Code

    I am using an Excel file to store primarily demographic data. I have two pieces of code imbedded in this workbook that allows me to use a Combobox to select demographic data and change to an abbreviation. For example Green -> GR, Purple ->PUR. The code has affected my ability to double click...
  5. C

    Double click Cell to open another workbook

    Hello, I have a question about how to double click cell to open another workbook. In my sheet 1 of workbook1, i would like the user to be able to double click any of cells in column A (that may or may not have text in them) to open up another new workbook. Each cell at A column, when double...
  6. D

    double click opens userform with listbox, how to stop same dbl click causing listbox selection

    Hi, I have a userform which opens when I double click a cell Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Not Application.Intersect(Target, Range("G2:G501")) Is Nothing Then Cancel = True UserForm1.Show End If End Sub My problem...
  7. R

    Macro that adds a code to an existing worksheet to allow a range of cells a double click (today's date) option.

    I know very little about VBA and don't use it on a regular basis to learn much. I normally find code from a Google search, paste it in and modify it to fit my needs. Below simply inserts code from a module to an existing worksheet. 'This inserts code from a module to an existing worksheet Sub...
  8. T

    Code to input text requires double click to work

    I have a piece of code that is set to input "yes" or "no" into a specific cell dependant on user input on a different sheet. I can only get the "yes" or "no" to appear when I double click the cell and press enter. Is there anyway to refresh or double click the cell within VBA? I have checked the...
  9. V

    Assign value to shape by double clicking

    Hi everyone, Can anyone help with vba code on assigning value to a shape in an excel sheet through double click event. I have a number of different types of shape on the sheet, I want to be able to assign values such as time value etc. to each one by just double clicking on them. Thanks in...
  10. D

    VBA for double clicking a specific cell to bring you to a different specific cell (or sheet)

    I am hoping to write a VBA/macro so that when I double click on a specific cell that it brings me to a different cell (or in this case a different sheet inside the same workbook). To elaborate I want to be able to input text into cell B3 if it's a basic answer, however if it requires more...
  11. D

    On Double Click or On CTRL Click for many Shapes

    All, This is my first post to this board, I have tried searching the board and I haven't been able to come up with an answer. I am fairly new to VBA and have a question regarding the on double click private sub and how to assign it to shapes (CTRL click would work as well). I have a sheet that...
  12. L

    Dynamic Userform on Double Click

    Hello everyone. First, I hope I'm posting in the right place. I'm new to the forum. I have a spreadsheet that opens an input box when I double click a row within column F. The contents of the input box is then placed into the corresponding row of column AA when I click OK. (i.e. If I'm in...
  13. Z

    doubleclick Copy/paste cell VBA: Going one further

    Hi, I have had moderate sucess with my first few attempts at implementing vba code but I am still struggeling a bit here and I cant tell how advanced this problem may become to solve. In the below table I am trying to create a macro(s) that will: 1. upon doubleclick in cell of column "fruit"...
  14. D

    Pivot Table Double click/Show Details Auto Update

    I am wondering is there a possibility that when I Refresh Pivot Table, the Table (that is created by double click or Show Details) also Refreshes?
  15. B

    need to double click HTML table cell

    I'm trying toautomate Internet Explorer using Excel VBA. I need to double click a cell within an HTML table.<o:p></o:p> <o:p> </o:p> This lineresults in the proper data so I know I have the correct cell:<o:p></o:p> temp...
  16. J

    VBA to double-click through a range

    I am trying to get my code to double-click through a range in column B. The range is determined based on the where there is a blank cell in column A - see code below. The issue I'm having is that the double-click works for the first cell within the range but it then jumps to the first cell...
  17. R

    Macro to add date when you double click a cell in a specific range

    Hi, I'm trying to figure out how to write a macro that will add date to a cell if you double click it. But this feature should only apply to a range of cells $C4:$E1000. The date should not change the next day when the file is opened
  18. N

    copy cell on double click to another worksheet

    Hello, I know there are other threads on this subject, but because of my poor knowledge in vba I couldn't adapt the answers to my problem. What I need: WhenI give two clicks in a cell (c3:d10, worksheet"PM") , copy the cell's value and paste on D1, worksheet"PLANEJAMENTO". Thank you.
  19. C

    Double Click on an Excel File Open in a new Window Not in the same window as an excel spreadsheet that is already open

    How do I set an option so whenever I double click on an excel file it opens into a new window rather than the same window of an excel spreadsheet that I already have open. I get the purpose of having it open into the same window that is already open, it is so you can copy/move sheets, apply the...
  20. A

    Drop-Down List In Expanded Data from Pivot Table

    Hello everyone! I'm creating a report using a pivot table that when users double click their name and dollar value, a separate sheet will be created with data only pertaining to their name. This part is done. However, I also want one of the columns, dubbed "Action List", to have a pull-down...

Some videos you may like

This Week's Hot Topics

Top