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
 

steve case

Well-known Member
Joined
Apr 10, 2002
Messages
788
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.
 

Dickbee

New Member
Joined
Nov 23, 2005
Messages
2
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. :)
 

Forum statistics

Threads
1,078,117
Messages
5,338,314
Members
399,226
Latest member
arictarhvasiliev

Some videos you may like

This Week's Hot Topics

Top