Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
using gui controls
I want to produce a simple application for my kids primary school using Excel
2003. The worksheet will have the alphabet listed and underneath each letter there will be a corresponding value (ie a =1 through to z =26). The kids will then write a name (or other single word) in a cell and the relevant letters would be choosen in the alphabet table and its calculated 'value' output into another cell. Thanks for any help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
using gui controls
If say "ABE" is entered in the designated cell then is the result... 125 or 8 (sum) or 10 (product)? How would this meaningful to school kids? -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "daddy260" wrote in message I want to produce a simple application for my kids primary school using Excel 2003. The worksheet will have the alphabet listed and underneath each letter there will be a corresponding value (ie a =1 through to z =26). The kids will then write a name (or other single word) in a cell and the relevant letters would be choosen in the alphabet table and its calculated 'value' output into another cell. Thanks for any help |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
using gui controls
Well, for what it's worth - here's something you could start with. Has code
attached to the sheet. Right-click on tab name and choose [View Code] to see/edit it. Worksheet is protected without a password: code will put it back into protected status, so to work on the sheet I suggest you open the file and choose not to enable macros then unprotect the sheet. I figure younger kids would probably like some pictures/graphics on it also? Letters used in the word(s) are shaded and the total 'score' is reported each time the entry in the green-shaded cell is changed. "daddy260" wrote: I want to produce a simple application for my kids primary school using Excel 2003. The worksheet will have the alphabet listed and underneath each letter there will be a corresponding value (ie a =1 through to z =26). The kids will then write a name (or other single word) in a cell and the relevant letters would be choosen in the alphabet table and its calculated 'value' output into another cell. Thanks for any help |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
using gui controls
Oops, forgot the link to the file:
http://www.jlathamsite.com/uploads/NameGame.xls "daddy260" wrote: I want to produce a simple application for my kids primary school using Excel 2003. The worksheet will have the alphabet listed and underneath each letter there will be a corresponding value (ie a =1 through to z =26). The kids will then write a name (or other single word) in a cell and the relevant letters would be choosen in the alphabet table and its calculated 'value' output into another cell. Thanks for any help |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
using gui controls
Thank you, this provides all the functionality we will require.
"JLatham" wrote: Oops, forgot the link to the file: http://www.jlathamsite.com/uploads/NameGame.xls "daddy260" wrote: I want to produce a simple application for my kids primary school using Excel 2003. The worksheet will have the alphabet listed and underneath each letter there will be a corresponding value (ie a =1 through to z =26). The kids will then write a name (or other single word) in a cell and the relevant letters would be choosen in the alphabet table and its calculated 'value' output into another cell. Thanks for any help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
See names of controls | Excel Discussion (Misc queries) | |||
Coupled controls? | New Users to Excel | |||
Forms controls | Excel Worksheet Functions | |||
ActiveX Controls vs Form Controls | Excel Discussion (Misc queries) | |||
Active X controls | Excel Discussion (Misc queries) |