A question about code to write when clicked.

%3CLINGO-SUB%20id%3D%22lingo-sub-2575753%22%20slang%3D%22en-US%22%3EA%20question%20about%20code%20to%20write%20when%20clicked.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2575753%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%20I%20have%20attached%20a%20visual%20to%20this%20message%20as%20an%20example%20of%20what%20I'm%20looking%20for.%20I'm%20having%20trouble%20finding%20VB%20code%20to%20plug%20in%20for%20this%20project%20I%20need%20to%20get%20done.%20Here%20is%20what%20I%20would%20like%3A%20when%20I%20click%20on%20%22John%22%20I%20want%20the%20next%20cell%20to%20be%20his%20name%20and%20then%20the%20red%20cells%20in%20his%20row%20filled%20in%20with%20specific%20numbers.%20Then%2C%20if%20I%20were%20to%20click%20on%20%22Baker%22%20it%20would%20do%20the%20same%20thing%2C%20it%20would%20fill%20Baker's%20row%20with%20his%20name%20and%20then%20specific%20numbers.%26nbsp%3B%20I%20have%20about%20fifty%20names%20that%20need%20to%20have%20this%20same%20thing%20done%20to%20them.%20What%20would%20be%20the%20easiest%20way%20to%20do%20this%3F%20Thank%20you%26nbsp%3B%3CEM%3ESO%3C%2FEM%3E%20much%20for%20your%20help!%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22EXAMPLE.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F297657i01D71026E8B49932%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22EXAMPLE.png%22%20alt%3D%22Example%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EExample%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2575753%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello! I have attached a visual to this message as an example of what I'm looking for. I'm having trouble finding VB code to plug in for this project I need to get done. Here is what I would like: when I click on "John" I want the next cell to be his name and then the red cells in his row filled in with specific numbers. Then, if I were to click on "Baker" it would do the same thing, it would fill Baker's row with his name and then specific numbers.  I have about fifty names that need to have this same thing done to them. What would be the easiest way to do this? Thank you SO much for your help! ExampleExample

0 Replies