Macro that shows the contents of a range

Closed

Stevie - May 5, 2010 at 11:44 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 6, 2010 at 07:38 AM

Hello,

I'm trying to create a macro that would show the contents of a range of cells. I would like to assign this macro to the botton on the forms toolbar. The range of cells is in Column B.

What I want is to be able to click on the botton and have the the contents from the range of cells appear. Is this possible ?

Thanks

Macro that shows the contents of a range
Call of duty: black ops – zombies downloadable content - Download - Shooters
Spell number in excel without macro - Guide
Apple airtag range - Guide
Clear only the formatting from the selected cell (leaving the content) - Guide
Treasure of nadia downloadable content - Download - Adult games

2 responses

Answer 1 / 2

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 5, 2010 at 03:02 PM

What do mean exactly by "appear"?

Stevie
May 6, 2010 at 07:33 AM

I have a formula on column B that says "Happy Birthday Name" on their birthday. Column B is hidden, there are about 400 rows in this column. What I want to do is to insert a button so that all the cells that has data in column B show up when the button is clicked. thanks.

Answer 2 / 2

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 6, 2010 at 07:38 AM

Not possible. You can either hide a column or show a column, You can partially show a column for some rows only. What you can do is have the column there and let the "Happy Birthday" show up when it is time it to be shown. In other case it just shows ""

some thing like this
=if(a1=today(), "Happy Birthday", "")

Similar discussions

Excel Macro/Code help: Creating sheet for each name in column of another sheet

Copy range data in a column to new column.

Similar discussions

Subscribe To Our Newsletter!