Exclusive

am trying to create something.

now just say i have created a form

and i have to options for a user to click (i am still trying to do this)

eg

Age
18-22
23-25

When a user clicks 18-22 i want it to go to another part form
When a user clicks 23-25 i want text to appear at the bottom of the form

is this possible ?

__________________

devil666x

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.

daveleebond

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.

bodser

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

__________________
Dreambox - DigitalWorldz 2.0 - PURE - Leics