|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Please help. I want to change the text of a cell when another is selected
I am looking for HELP For Excel: I want to be able to click on a cell for example M10, and have the contents of Cell G7 change. If I click another cell for example M14, the contents of Cell G7 will change again. If neither cell is selected I want the text in Cell G7 to be of default text. I am awful at VB. I attempted to create a VB script but the error code response was: "What are you trying to do you big dummy? Go online and ask someone who is smarter than you" Any help is always appreciated! Last edited by frankzelnik; 06-19-2018 at 09:32 AM. Reason: Forgot to add "I need Help" |
#2
|
|||
|
|||
Do you consider use of the Enter key or Tab key getting you into M10 or M14 the same as clicking M10 or M14 to select them ?
|
#3
|
|||
|
|||
NoSparks I prefer mouse click by selection. I have considered a macro button but I need the macro behind it
|
#4
|
|||
|
|||
Sorry, limiting the firing of a macro to the cell being selected by mouse click only is beyond me.
Quote:
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? |
#5
|
|||
|
|||
The goal is to be able to practice learning Spanish. I want to switch from present tense verbs to past tense; and then present to future tense.
|
#6
|
|||
|
|||
I am trying to get better at learning the different verb translations. It may be easier if I create all 3 different tenses and by assigning an input (say mouse click or as you suggest tab) to hide certain rows/columns? I am old school in the regards to learning. I feel it is better to write and make notes rather than just read and try and remember.
|
|
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 |