Please help. I want to change the text of a cell when another is selected

		Microsoft Office Forums > Microsoft Excel > Excel
Please help. I want to change the text of a cell when another is selected

FAQ

Thread Tools

Display Modes

06-19-2018, 11:44 AM

NoSparks

Windows 7 64bit Please help. I want to change the text of a cell when another is selected

Office 2010 64bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

Sorry, limiting the firing of a macro to the cell being selected by mouse click only is beyond me.

Quote:

I have considered a macro button but I need the macro behind it

Mind if I ask the goal for this?
It doesn't seem logical to me for the value of G7 to change from its default value for just the time M10 or M14 is selected (with no concern as to their values), then go back to its default.
What are you trying to accomplish?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Change Text Colour in Cell Based on Text in Same Cell	PMC11	Word VBA	1	11-14-2017 09:15 PM
Clear all cell colors within a range starting at cell A8 and change row of active cell to yellow	FUGMAN	Excel Programming	7	02-05-2017 08:37 AM
Macro to change all text color to black in all docx files in a selected folder	joewoods	Word VBA	13	05-16-2016 06:29 PM
Margin change for selected text in Word 7	Richtriebe	Word	4	03-14-2016 11:57 AM
Change cell color everytime a value is selected in dropdown list	angelica_gloria	Excel	4	01-27-2012 06:47 PM