Setting up a timesheet where automatically letter equals number

[office bunny]

Is there a way to set up a time sheet where a letter automatically equals a
value (eg: E = 7.5)? I would love to be able to simply type in simple letters
to indicate shift types and have have total times appear at the bottom of the
time sheet. Right now I am doing it manually.

 

[Steve Schapel]

Bunny,

There are a number of approcahes that could be taken to this. I can't
really picture exactly what you are trying to do, so not sure which
angle would be the most suitable. You caould set up an AutoKeys macro,
where you define certain keystroke combination to be associated with
certain numerical values, so you press the keys and it will use SetValue
macro action to enter that number in the active control. Or, you could
set up a table with 2 fields, one with the Letter and the other with the
corresponding NumberValue, and then on your form you could put a
combobox with this table as the Row Source, and when the letter is
typed, the associated number is recorded. Or, you could put a macro or
a VBA procedure on the After Update event of a textbox, so that it
assigns a value to the relevant field according to the letter typed into
the textbox.