Value of a cell

[Foo_Man_Chu]

Hi All,

I've got a cell that contains a button. When the button is clicked, I need to reference the value of the cell next to the cell that contains the button that was clicked. I know this is probably super simple but I can't seem to get it. Any help will be greatly appreciated. Thanks!

 

[mole999]

where do you need to reference the cell

use its value, copy it somewhere, add it to a calculation ?

does the cell move

is it always numeric or text or mixed

 

[Foo_Man_Chu]

The button is a delete button, and it deletes the row that it is located on. What I want to do is take the text value of the cell next to the cell the button is located on and use that value in a message box that says "Are you sure you want to delete " & the text in the cell next to the button's cell. The cell should always be next to the cell containing the delete button for that row. The type of data in the cell next to the button cell should be treated as text.

 

[Foo_Man_Chu]

Ok, here is code that I came up with to give me what I need. If there is a simpler way of doing it, I'd love to see it to make my code better, thanks!

Cells(ActiveSheet.Buttons(Application.Caller).TopLeftCell.Row, ActiveSheet.Buttons(Application.Caller).TopLeftCell.Column + 1).Value