Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accelerator Property
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accelerator Property
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." wrote in message ... | 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 | | |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accelerator Property
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 ... 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." wrote in message ... | 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 | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't see the Accelerator line?? | Excel Programming | |||
Accelerator | Excel Programming | |||
Accelerator keys | Excel Programming | |||
Option Button Accelerator Key | Excel Programming | |||
Accelerator Keys | Excel Programming |