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
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

steve case

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

Watch MrExcel Video

Forum statistics

Threads
1,118,423
Messages
5,572,017
Members
412,431
Latest member
Huuktkt
Top