Floating Key

M

Mr-Re Man

I would like to create a floating key that allows users to view a simple drop
down box that shows them what task they should be inputting on a worksheet.

The drop down box needs to be visble on opening and float at the top of the
worksheet like a toolbar can.

Then the user can click the drop down button and a list of 20-30 tasks will
appear with a code that can used to fill in the spreadsheet.

eg. in the dropdown box will be:-
1. Open Mail
2. Frank Mail
3. Filing
4. Plan Printing

They'll know No.4 is for plan printing and add that code number to a cell.

I was going to put the key at the top of the worksheet but as I have frozen
some rows and columns, this key would disappear.

Any ideas?
 
J

Jim Cone

Any ideas?,

You could create a list of your tasks on a spreadsheet and then use the
"Watch Window" to display them.
See Tools | Formula Auditing | Watch Window.
Also read Excel help under "Watch a Formula"

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



I would like to create a floating key that allows users to view a simple drop
down box that shows them what task they should be inputting on a worksheet.
The drop down box needs to be visble on opening and float at the top of the
worksheet like a toolbar can.
Then the user can click the drop down button and a list of 20-30 tasks will
appear with a code that can used to fill in the spreadsheet.
eg. in the dropdown box will be:-
1. Open Mail
2. Frank Mail
3. Filing
4. Plan Printing
They'll know No.4 is for plan printing and add that code number to a cell.
I was going to put the key at the top of the worksheet but as I have frozen
some rows and columns, this key would disappear.
Any ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top