double-click

Hey Excel Guru's I need some Help to change Colour if Multi page is Activated By Double-click on Specific cell.... All the Function with Double-click works it's the Colour Part i need... example I Double click on Cell "B1" then the Multi page side Should Change Background - Colour So that...

Hi Everyone, So I have a workbook set up with a Worksheet_BeforeDoubleClick set up that launches some code if I double-click some cells in a given range. Now what I want to do is use VBA to double-click a certain cell based on some criteria (to activate what's inside the...

Hi All, I have a spreadsheet with two worksheets. what i would like to do is when a cell within column D on worksheet 2 for example is double-clicked on, it will copy the data from that cell into cell B2 on worksheet 1. Likewise, if possible, I would like to make it so that double clicking on...

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...

Hello, I need some VBA code to address the following: Scenario: A pivot table reveals a probable error in the underlying source data. The error needs to be located and corrected in the source data, and then the pivot table needs to be refreshed. *Problem*: The double-click action on a pivot...

Someone has told me that you are able to add the remainder of a percent by double clicking a cell but that someone forgot how to do so. For example, say you have a column with the following numbers 30% 20% 10% 0% 10% You want the 5 boxes to add up to 100%. I heard that there is a trick, where...