Accelerator Property

[Ronald R. Dodge, Jr.]

Excel 2002, SP3

Can this property only be set in Design mode or can it also be set in
Run-Time mode for MSForms.Label Objects?

I am attempting to have it set in runtime mode as it's in run time mode when
the labels are being filled out. However, I'm not seeing the letter being
underlined on the form for each label that is suppose to have the
accelerator key set. Also, no 2 objects (or in this case, labels) has the
same letter.

--
Thanks,

Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000

 

[Homey]

i see this change label accelerator in userform for me so it seem the answer
is it can be done at runtime.

Private Sub CommandButton1_Click()
Me.Label1.Accelerator = "e"
End Sub


| Excel 2002, SP3
|
| Can this property only be set in Design mode or can it also be set in
| Run-Time mode for MSForms.Label Objects?
|
| I am attempting to have it set in runtime mode as it's in run time mode
when
| the labels are being filled out. However, I'm not seeing the letter being
| underlined on the form for each label that is suppose to have the
| accelerator key set. Also, no 2 objects (or in this case, labels) has the
| same letter.
|
| --
| Thanks,
|
| Ronald R. Dodge, Jr.
| Production Statistician
| Master MOUS 2000
|
|

 

[Ronald R. Dodge, Jr.]

What happened, given I can't have 2 files open at the same time, I had put
in the accelerator letters within the worksheet of one workbook, but not the
other, so it was an overlook on my part. Got the stuff to work as expected.
Just doing some significant modifications to one of my programs that has to
be adjusted on a file by file basis given the various issues of Excel and
the codes for the different work centers are different. Turn around time on
these modifications has to be pretty quick too. Would be nice to do this
stuff in a database environment (thus why I attempted to use Access, but
there's some significant limitations and other issues in it that prevents me
from using it), but don't really have one available to me with what I have
to work with.

--
Thanks,

Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000