Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

Macro that shows the contents of a range [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 -
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

Answer 1 / 2
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 767
What do mean exactly by "appear"?
Report

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
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 767
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", "")
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!