Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comments to help Users
Hello
I'm not sure if I just haven't found the right functionality or whether I need code for this but any advice on either/or is much appreciated. I want to add help comments to a spreadsheet, which is essentially a questionnaire. For each question which is in a frame object there are option buttons to select answers I would like to put an info 'i' next to each of these which either when clicked or highlighted over will bring up a comment box in which i can give hints, tips etc. (exactly like this website does when you hover over the links to the left!!) The insert comment function for each cell doesn't do what I want because the layout of the questionnaire is in a userform format from control toolbox. Hope someone can give me some inspiration!! Cheers Laura |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comments to help Users
Hi Laura,
Use the ControlTip Text property. When the user's mouse passes over the control, the text appears. HTH, Greg "LauraC" wrote in message ... Hello I'm not sure if I just haven't found the right functionality or whether I need code for this but any advice on either/or is much appreciated. I want to add help comments to a spreadsheet, which is essentially a questionnaire. For each question which is in a frame object there are option buttons to select answers I would like to put an info 'i' next to each of these which either when clicked or highlighted over will bring up a comment box in which i can give hints, tips etc. (exactly like this website does when you hover over the links to the left!!) The insert comment function for each cell doesn't do what I want because the layout of the questionnaire is in a userform format from control toolbox. Hope someone can give me some inspiration!! Cheers Laura |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sharing excel sheet with multiple users, but other users cant see | Excel Discussion (Misc queries) | |||
How do I lock a worksheet while allowing users to add comments? | Excel Discussion (Misc queries) | |||
Excel-comments entered by users disappear in a shared excel-sheet | Excel Worksheet Functions | |||
How to you lockout the comments in Excell from other users? | Excel Discussion (Misc queries) | |||
Help - Automating a file.. Adding Users , Deleting users, Changing | Excel Worksheet Functions |