Macros without buttons

[imported_unknown]

Hey gang,

I'm still new to macros so I was wondering if anyone could help me out.

I've recorded a macro and would like to attribute it to a cell that has text writing in it. I do not want to attribute it to a button.

Is this possible, if so, how?

Thanks in advance.

 

[lenze]

Do you want to run the macro when the cell is selected, or when it changes?

 

[imported_unknown]

I want to run it when the cell is selected.
I am looking at another spreadsheet that does exactly what I want to do, but I can't find any of the macros in it.

I basically want to click the text in the cell and jump to specific part of the spreadsheet.

Is there a command I'm missing? In the spreadsheet that I'm looking at, it looks like a macro.

Thanks for the help!

 

[lenze]

Open up your WorkBook and right click on the Sheet Tab. Choose View Code. Enter this code
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address<> "$A$1" Then Exit Sub
'Put your code here
End Sub

Adjust address as needed

HTH
This message was edited by lenze on 2002-10-03 16:55

 

[Richie(UK)]

Hi Anthony,

The reason that you probably haven't seen the code for the workbook that you are looking at is that you need a worksheet event macro, ie a macro that is triggered when a certain change takes place to a worksheet.

Right-click the sheet tab for your chosen workbook and select View Code. Then paste in the following macro by way of example:<pre>
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Dim MyCell As Range
Set MyCell = Worksheets(1).Cells(10, 1)
If Target.Address = MyCell.Address Then MsgBox "You selected A10!"
End Sub</pre>

Simply replace the example code with your own code. Any problems - repost with the code you are using and a description of the problem.

HTH

EDIT: Sorry lenze - busy drafting a reply and didn't refresh to check for further posts.

_________________<font color="blue"> «««<font color="red">¤<font color="blue"><font size=+1>Richie</font><font color="red">¤<font color="blue"> »»»</font>

</gif>
This message was edited by Richie(UK) on 2002-10-03 17:13

 

[lenze]

By the way, if all you want to do is jump to another location in the workbook, why not just use a hyperlink?

 

[imported_unknown]

Lenze,

That's what I ended up doing. Seems easy enough.

Thank you all for the help!!