Cell click detect or Dynamic Button text

Dickbee

New Member
Joined
Nov 23, 2005
Messages
2
I have a table of numbers that dynamically change, they are linked from another sheet, which is taking some DDE input.

I would like to be able to either single left click on any of the cells with the number in & have either a formula or a macro execute. Alternativly can the text on a button be made dynamic so that I can click on that?

Many Thanks
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
How about a worksheet macro?

Alt+F11 or [Tools then Macro then Visual Basic Editor]

Under the VBAProject(YourFileName) Microsoft Excel Objects Click on Sheet#(YourSheetName)

In frame on the right that comes up choose "worksheet" and you should see the following:

_______________

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

End Sub

_______________

Insert your code there.

I just asked similar questions earlier:

http://www.mrexcel.com/board2/viewtopic.php?t=180814&highlight=

http://www.mrexcel.com/board2/viewtopic.php?t=180831&highlight=

Hope that helps.
 
Upvote 0
Hi

Thanks for the reply. Didn't realise it was so easy to trigger a macro from clicking on a cell. Exactly what I needed, just need to write the code now. :)
 
Upvote 0

Forum statistics

Threads
1,213,549
Messages
6,114,264
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top