Excel, Creating text with a colored rectangle
February 2, 2014 9:40 AM   Subscribe

Could anyone provide me guidance with a subroutine that would paste text within a colored rectangle within an Excel document? Thanks, Ken
posted by estudioken to Computers & Internet (2 answers total)
First paste your text into Excel.

Then select the cell you want to have a border around it and choose Borders -> More Borders (Screenshot)

From this window (screenshot) you can choose exactly the style and color of border that you want.
posted by JDHarper at 10:11 AM on February 2, 2014

This is how you add a shape with text via vba


Pasting can be as easy as selecting that shape and doing a Selection.paste or Selection.pastespecial + parameters

But depending on where the text comes from, etc. it can get more complex than it should. DoEvents might be useful in that case.

posted by magullo at 10:56 AM on February 2, 2014

« Older Dynamic sharing economy workers - where to find...   |   Why am I not losing weight? Newer »
This thread is closed to new comments.