eliminating command button from userform with empty relative cells

[Amin Kaveh]

Hi there!
I have some problem and I will wonder if you help me on this.
I have a calendar with 12 command buttons with name month_1, month_2 , ... ,month_12 and almost 365 command buttons with name day_1_1, day_1_2, ... ,day_12_29 and also 365 cells in a separate worksheet relative to this command buttons with name like calendar /01/01, /01/02, ... /12/29.

What I want is the elimination of command button when relative cell is empty.
I will appreciate answering this question.

 

[Amin Kaveh]

Hi there!
I have some problem and I will wonder if you help me on this.
I have a calendar with 12 command buttons with names month_1, month_2 , ... ,month_12 and almost 365 command buttons with names day_1_1, day_1_2, ... ,day_12_29 and also 365 cells in a separate worksheet relative to these command buttons with names like calendar /01/01, /01/02, ... /12/29.

What I want is the elimination of command button when relative cell is empty.
I will appreciate answering this question

 

[mikerickson]

Rather than removing the buttons, it is easier to hide the ones you don't need.

How does one know which cell is associated with which command button?

 

[Amin Kaveh]

yes, I mean to hide the command buttons.
The cell value 01/01 is relative to command button day_1_1 and cell value 01/02 is relative to day_1_2 and .....

 

[My Aswer Is This]

I never believe it's a good plan to have large numbers of command buttons or other controls to perform a task.

We can write you scripts that would be activated when you double click on a cell.
Doing things this way requires very little code and no need for 365 buttons.

Please explain your ultimate Goal.

Like if the current Date is 8/29/19 enter "Hello" in Sheet("Alpha") Range("A45")

Or why not select the Month from a Combobox.