double click vba

  1. R

    Issue with Worksheet_DoubleClick VBA Formula

    Good Afternoon, I'm working on a macro to activate a named worksheet when a cell with the corresponding name on a separate worksheet is double-clicked on. I tried to use a macro suggested in another thread but it doesn't seem to work. For reference I am working in the O365 desktop version of...
    • Rob W
    • Thread
    • double click vba office365 excel vba & excel
    • Replies: 5
    • Forum: Excel Questions
  2. J

    Double Click to change color

    I am looking to use the RGB values for a specific color (other than those in the 56 color palette) I have tried just using: Case 45=Target.Interior.Color= RGB(102, 102, 255) Case RGB(102, 102, 255= Target.Interior.Color= RGB(255, 255, 51) But when i do this it reaches the first RGB and locks up...
  3. 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...
  4. A

    Copy a cell on double click and paste to a different cell

    Hi, I am looking for a bit of steer on some VBA that will allow me to: - Double click on a cell within a range (C11:AI24) - On Double clicking, it will take the content of the cell I have double clicked on (could be any cell in the above range) and pastespecial values into a different cell...
    • admack
    • Thread
    • cell double double click vba pastespecial vba copy / paste
    • Replies: 5
    • Forum: Excel Questions

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top