Hi there, I'm creating an assessment tool (to evaluate water security in rural, resource-limited communities) and would like to provide guidance As Needed by the users. I'd also like to save screen space and not overwhelm the user, so I'd like to rule out using simple text boxes.
My inspiration is found in this assessment tool:
http://whqlibdoc.who.int/publications/2010/9789240500938_eng.xls
To see this GuidanceForm in action, upon opening the file, click "Enter assessment", and then from the ListBox control at the top choose "Table 1". A pop-up should appear entitled "Guidance". This can be turned on/off by a CheckBox (cell N17).
Note two things:
[list type=decimal]
[*]It is "modeless" (users can still interact with the spreadsheet while it is up - easy to do with
- I think this can be taken care of by using the Worksheet_SelectionChange[/code] event procedure.
[/list type=decimal]
I've had a look at the source code, it looks a bit tangled for a novice like me. Anybody have reasonable suggestions or a link where I could learn more? No big pressure, I'm wrapping up my thesis and this is lower priority.
Thanks in advance.
FYI: Background info for those interested: http://www.who.int/water_sanitation_health/publications/wsp_qa_tool/en/index.html
My inspiration is found in this assessment tool:
http://whqlibdoc.who.int/publications/2010/9789240500938_eng.xls
To see this GuidanceForm in action, upon opening the file, click "Enter assessment", and then from the ListBox control at the top choose "Table 1". A pop-up should appear entitled "Guidance". This can be turned on/off by a CheckBox (cell N17).
Note two things:
[list type=decimal]
[*]It is "modeless" (users can still interact with the spreadsheet while it is up - easy to do with
Code:
vbModeless
Its contents change depending on the position of the [code]ActiveCell
[/list type=decimal]
I've had a look at the source code, it looks a bit tangled for a novice like me. Anybody have reasonable suggestions or a link where I could learn more? No big pressure, I'm wrapping up my thesis and this is lower priority.
Thanks in advance.
FYI: Background info for those interested: http://www.who.int/water_sanitation_health/publications/wsp_qa_tool/en/index.html