referencing a button on an activecell

[aspiringnerd]

I can use the following to reference a cell based on the location of the button

ActiveSheet.Buttons(Application.Caller).TopLeftCell.Select

but can you do the opposite? I want to reference a button based on the active cell.

ie if I have cell a1 selected then I want to reference button 1, and if I have a2 selected then I want to reference button 2 (assuming each row gets a button)

 

[My Aswer Is This]

Why have all these buttons?
Why not double click A1 and a script will run.
double click A2 and a script will run. And on and on.
If this would work let me know what you want to happen when you double, click on Range A1 and on and on.

 

[aspiringnerd]

Why have all these buttons?
Why not double click A1 and a script will run.
double click A2 and a script will run. And on and on.
If this would work let me know what you want to happen when you double, click on Range A1 and on and on.

I'd like a button to be dependent on if an xlookup return is true. The only way I thought of doing it is to always have a button but hidden and only shows when xlookup (via VBA) returns a value. The button will always have the same script.

 

[My Aswer Is This]

I would not be able to help with this.
Maybe someone else here will be able to help you.
Showing and hiding a large number of buttons is not something I would suggest.

You said:
"assuming each row gets a button)"

There are nearly 1.5 million rows having 1.5 million buttons would be difficult.

 

[aspiringnerd]

I would not be able to help with this.
Maybe someone else here will be able to help you.
Showing and hiding a large number of buttons is not something I would suggest.

You said:
"assuming each row gets a button)"

There are nearly 1.5 million rows having 1.5 million buttons would be difficult.

Max 1000, I've already solved that part tho. I just need to reference a button based on the cell it's in, not based on what it is called.

 

[aspiringnerd]

I would not be able to help with this.
Maybe someone else here will be able to help you.
Showing and hiding a large number of buttons is not something I would suggest.

You said:
"assuming each row gets a button)"

There are nearly 1.5 million rows having 1.5 million buttons would be difficult.

I guess another route is to just create the button and attach the macro...I'll give it a try in the morning

 

[My Aswer Is This]

You said:
"The button will always have the same script."

Show me the script you will have in the button.