Macro that shows the contents of a range

Closed
Stevie - May 5, 2010 at 11:44 AM
rizvisa1 Posts 4479 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

2 replies

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
May 5, 2010 at 03:02 PM
What do mean exactly by "appear"?
0
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.
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
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", "")
0