Macro to move a shape once and move it back again on sequential presses.

**ynot2010** · 12-13-2010, 07:25 AM

Hi all,

Is it possible to write a macro that moves a shape to a certain location when a form button is pressed BUT then only move it back to its original position when the same form button is pressed? i.e. move a shape backwards and forwards between fixed locations on sequential presses?

I can write a macro to move a shape once, but obviously, when i press it again, it moves the shape the same distance as it did the first time it was pressed.

Any assistance would be very much appreciated.

Cheers.

**StephenR** · 12-13-2010, 07:29 AM

You could record the position of the shape before it is moved and then move it back to that position after the button is pressed?

**Domski** · 12-13-2010, 07:34 AM

Or have 2 shapes and switch the visible property:

Please Login or Register  to view this content.

The only advantage of this is you don't have to hard code the position into your vba.

Dom

**snb** · 12-13-2010, 07:54 AM

Record the defaultposition of the shape in the shapeproperty 'alternativetext':

Please Login or Register  to view this content.

Create a Togglebuttons (ActiveX-control) in the sheet

Use this code in the click-event of the togglebutton

Please Login or Register  to view this content.

Cfr. the attachment

**ynot2010** · 12-14-2010, 03:10 AM

That is great help, thanks!

Is it possible though to have multiple shapes toggle on and off and be linked to each other?

i.e. i have a 50 question quiz and only want 10 questions to be viewed at any one time. Due to formatting issues with the s/s, hiding rows and columns is not possible, thus the easiest thing to do i believe is have shapes cover 40 questions at any one time. I was thinking that you may have 4 (or 5?) form buttons that once pressed expose a different set of 10 questions. Is this the right approach? Is it possible to use toggle buttons to do this as described above.

Again, any assistance is appreciated. Thanks.

**Domski** · 12-14-2010, 04:20 AM

IMHO hiding the questions with shapes is probably over complicating the matter. Why not just have the font colour the same as the background of us a custom format of ;;; to hide what you don't want people to see. You can also use sheet protection to restrict what areas of the worksheet a user can select until required.

Dom

**ynot2010** · 12-14-2010, 06:43 AM

Dom, How do i do that? i.e. "You can also use sheet protection to restrict what areas of the worksheet a user can select until required."?

**davesexcel** · 12-14-2010, 06:52 AM

PgDn to your next set of questions could be an option,
or place a hyperlink at the 10th question and hyperlink to the next set of 10

**ynot2010** · 12-14-2010, 07:05 AM

Thanks Dave but not too sure that will work well. S/S is compact and having hyperlinks will wreck the formatting. Looking to also print the final result.

I have attached the questionaire for reference. Looking to limit to single page view, i.e in this case 57 questions before moving onto 58-114 etc. In the attached file i have covered these questions with a shape and would like these to toggle on and off but would also look for the other quesions to toggle off sequentially.