erik.van.geit
MrExcel MVP
- Joined
- Feb 1, 2003
- Messages
- 17,832
Peter,
Not sure if we were talking about the same thing. Say you are reading a post with some formulas. Can you copy that post and return all formulas (and data) to the spreadsheet with a few buttonclicks?
Kristy,
I was thinking of userforms with a button "more options" - "less options". Should be quite simple.
little story
One of the largest tools I ever made was created for hundreds of users. (The estimations are between 1500 and 2500.) I was asked to create a second even simpler version, but decided to combine both: while the effort may have been larger at the start, it was easier to update the product later on.
I know how difficult it can be to "listen" to the users. As a phone-helpdesk of my own product my answers were often: "But it IS simple: check out the helpfiles.." or "Sure, you can do that! Didn't you see the button over there?".
Later on, when te product got more developed, I was asked to train the users: 90 minutes + free questions. Those training sessions - about 40 sessions with an average of 25 visitors - learned me how people think and look differently at the products. It became more clear how the product needed to look like to suit everybodys needs.
One of the general rules - to my sense - is: at first show only the strictly necessary, only when asked provide more options.
best regards,
Erik
Not sure if we were talking about the same thing. Say you are reading a post with some formulas. Can you copy that post and return all formulas (and data) to the spreadsheet with a few buttonclicks?
Kristy,
I was thinking of userforms with a button "more options" - "less options". Should be quite simple.
little story
One of the largest tools I ever made was created for hundreds of users. (The estimations are between 1500 and 2500.) I was asked to create a second even simpler version, but decided to combine both: while the effort may have been larger at the start, it was easier to update the product later on.
I know how difficult it can be to "listen" to the users. As a phone-helpdesk of my own product my answers were often: "But it IS simple: check out the helpfiles.." or "Sure, you can do that! Didn't you see the button over there?".
Later on, when te product got more developed, I was asked to train the users: 90 minutes + free questions. Those training sessions - about 40 sessions with an average of 25 visitors - learned me how people think and look differently at the products. It became more clear how the product needed to look like to suit everybodys needs.
One of the general rules - to my sense - is: at first show only the strictly necessary, only when asked provide more options.
best regards,
Erik