I have a admin entry form and would like to be able to use the tab key to move from sheet to sheet. The office people are really want this. Now the sheet order are not sequentially numbered meaning i.e. sheet 66 and next would be sheet 107 by tabbing.
I know, I know, I should have thought about planning this out sequential to begin with in the layout but did not think of this at the time and now it would be a huge rebuild to do. So my question is how can this be accomplished? VBA? Macro? I have tried recording a macro and mousing tab to tab to see the code but no luck.
I hope this is viewed as an awesome challenge.
Thanx all!!
Jim
Sheet.66 probably is group shape and contain a lot of sub-shapes. When you press TAB key all sub-shapes are skipped!
Would be something like catching the keypress event, when Tab-key go to the next shape. Next shape being identified by a number in a user or prop field.
The number would be set manually or clicking all relevant shapes in the right order???
none of the shapes (sheets) are grouped. Please see the attached screen shot. We never thought of have this tab action until we rolled out the pilot to be tested by the account managers and they requested this. We would like to tab in order meaning Poject Manager to Requested By, Customer Name and so on.
I will try what Yacine suggested and let you know. If anyone has a suggestion please let me know.
Thanx again!!!
in visio when you add new shape to page, each shape get their ID in order. In your picture you at first add some shapes, and later place these shapes as you need.
Sorry but i don't know how help you :(
Yea, as mentioned when we started this project we did not think of keeping the shapes (sheets) in numeric order for tabbing. Now to go back and re-order would be a huge undertaking. Looks like the navigating will need to be done by mouse. I was hoping to find maybe a VBA code that would state that when the tab key is used to move onto the next shape that would be in the code. (tab 66, tab 107 on so on.) a simplistic description I know.
This is way beyond my skill level.
Thank you for your reply!
Jim
simply way:
1. just delete shapes that you need to fill by text
2. add new shapes in required order
3. select another shapes and protect it from selection
in Developer ribbon Developer -> Protection -> From selection
Most all the shapes have formulas. Will doing this void those?
these shapes have formulas, or other shapes depends from these shapes ?
A bit of both
Why not do this in Excel? What you're showing is just a form. I've not searched recently, but there must be some programs out there that specialize in building forms.
Wapperdude
Why not do this in M$ Access?
both great questions. I am building an admin page in Excel as a data link that will populate all the sheets in Visio and it does work well.
However, because this project is in the testing phase with the office staff and we are not using the Excell file mentioned I was hoping to find a
solution for ease of operation being that they testers are accustomed to tabbing to entry fields. Look like there is no solution.
Our Visio file is far more complex that just this admin entry page. What we have is a product editor meaning that there is ever a
BOM page that once completed creates templates for graphics, job tickets and visual aids.
This site and all the help we have received has been a great benefit to us in building this!
I truly apperciate all the help!!
Idea...within Visio, you could add hyperlinks from one shape to the next. Not as convenient as <TAB> approach, but, it would send you to the next desired shape. Probably easier to just mouse over and select desired shape though.
Jim,
what version are you working with?
Just tried it in my new 2013 and noticed that the tab-key behaves completely differently.
It's a top-down and left-right rather than an ID suite.
Wonder if Google says something about it.
Hello Yacine, we are using 2010. We do have 2013 available in my department only, not company wide.
I will check 2013 and Google it. I will share my discoveries. Thank you.
Jim
We used 2010 to create this. I have 2013 at home and tried to use the Tab Key to navigate from sheet to sheet but doing so I get the same action as 2010. Looks like what I want to do in not doable. Thanx all for your help.
I really apperciate it!!
Hi Yacine, I just had a thought. If you found the tab key behaves differently in 2013 would you mind recording a macro while tabbing and send that to me? I would really apperciate it.
no action recorded! Sorry.
Hi Jim,
I kept thinking about your problem, because using visio as entry form is an interesting idea.
I collected some thoughts in the enclosed drawing.
1) would be Surrogate's suggestion, namely to protect all shapes, but the ones you need to edit
2) would be to catch the tab key press (you'll need to modify this to work without dialog)
3) work with a proper dialog
HTH and let me know what you think about,
Y.