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
"Homey" <none> wrote in message
news:%(E-Mail Removed)...
>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
>
>
> "Ronald R. Dodge, Jr." <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> | 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
> |
> |
>
|
Similar Threads
