excel help

Yes its possible mate. I can do the second bit, text apparing at te bottom of the form, but the first bit, th GOTO bit im not too sure about. I know it can be done though. Just having a read.

In any case, you will need to use VB to do this.

Just use hyperlinks for on each range and choose the 'place in document' option

you could RAR the xls you have done up to now and attach so it is easier to see what you are trying to achieve.

create them in buttons.....

1. create button called 18-22
2. right click button and assign macro (you may need to create new macro)
3. Use this as the macro (change A10 to whatever cell you want to go to)

Sub GoToCellX
Range("A10").Activate
End Sub

4. you may need to assign that macro to the button afterwards if you have other macros.

If you are using Office 2007 you need to set the macro security and save the document as an 'Excel Macro-enabled workbook'


I did this in Excel 2007, but I'm sure it will be the same for 2003 etc.
If you want me to send you this little test document let me know