Turning a Excel Cell into a button with macro?
Hi I wish to turn an Excel cell into a button, but the Google results does not seem very promising. Is it at all possible to create a proper button in a cell.
Normal or straightforward methods do not seem to work. Can anyone tell me where to start or confirm that it's just not impossible?
Re: Turning a Excel Cell into a button with macro?
In Excel using VBA you use the Worksheet_SelectionChange
Then, use an If to see if the selected cell is the one you want to use such as:
VB Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveCell.Address = "$A$1" Then
'code here as if it were your Button_Click event.
MsgBox "Instant button!"
End If
End Sub