VBA to add text into a range of cells if another cell has a specific value

**steve64** · 02-21-2016, 11:02 AM

I'd be grateful with some vba coding advice.

What I am trying to do is add a word "dummy" into a range of cells (T5:T39) if cell X47 ="0"

The code would need to run whenever the sheet is open.

I can do this a formula, but the range of cells (T col) are already populated automatically with that info coming via an api

Would I insert this as a module?

As always any help appreciated

**gmr4evr1** · 02-21-2016, 01:06 PM

This would be placed in the worksheet module for the sheet you want the code to run on.

Please Login or Register  to view this content.

**steve64** · 02-21-2016, 02:44 PM

Thanks Tom, much appreciated.
I have inserted the code in the worksheet module and saved it.
This runs a treat when I click run. But when the cell value changes nothing happens. Am I doing something wrong?
Cheers
Steve

**gmr4evr1** · 02-21-2016, 02:59 PM

I thought you wanted the code to run when the sheet was selected so I wrote the code for that. If you want it to run when the value in X47 is changed then change the sub title from
this...

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

**steve64** · 02-21-2016, 03:14 PM

Perfect
Thanks for your time and expertise Tom

**gmr4evr1** · 02-21-2016, 03:15 PM

No problem, glad I could help.

VBA to add text into a range of cells if another cell has a specific value

LinkBack

Thread Tools

Rate This Thread

Display

VBA to add text into a range of cells if another cell has a specific value

Re: VBA to add text into a range of cells if another cell has a specific value

Re: VBA to add text into a range of cells if another cell has a specific value

Re: VBA to add text into a range of cells if another cell has a specific value

Re: VBA to add text into a range of cells if another cell has a specific value

Re: VBA to add text into a range of cells if another cell has a specific value

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA to Find Specific Text, then Copy range to next open cell under specific text

Find specific text in cell that matches range, then display specific text

If a cell contains two specific groups of text in a range of cells, how to create a link?

[SOLVED] Return specific text if a different text is contained anywhere in a range of cells

[SOLVED] Highlight a range of cells if a single cell contains specific text

[SOLVED] Sum of Cells in One Range Dependent on Specific Text in a Different Range

Bookmarks

Bookmarks

Posting Permissions