Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accelerator
I am using Excel2000. I have a UserForm containing a CheckBox with the
caption Match case and I want to set c as the accelerator key, all in the same manner as Find. However, it is the first occurrence of c that becoming underlined and not the second as in Find. This is less meaningful as a mnemonic. What can I do about this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accelerator
In other programs you'd position the accelerator like this (in say VB)
Match &case However in VBA the accelerator will always find the first instance of the letter. But maybe you could capitalise the C in Case and assign "C" as the accelerator. I have no idea what you mean by "same manner as Find" and "not the second as in "Find", so I might have misunderstood your objective. Regards, Peter T "Dartmoor Graham" <Dartmoor wrote in message ... I am using Excel2000. I have a UserForm containing a CheckBox with the caption "Match case" and I want to set "c" as the accelerator key, all in the same manner as "Find". However, it is the first occurrence of "c" that becoming underlined and not the second as in "Find". This is less meaningful as a mnemonic. What can I do about this? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accelerator
"Peter T" wrote: In other programs you'd position the accelerator like this (in say VB) Match &case However in VBA the accelerator will always find the first instance of the letter. But maybe you could capitalise the C in Case and assign "C" as the accelerator. I have no idea what you mean by "same manner as Find" and "not the second as in "Find", so I might have misunderstood your objective. Regards, Peter T "Dartmoor Graham" <Dartmoor wrote in message ... I am using Excel2000. I have a UserForm containing a CheckBox with the caption "Match case" and I want to set "c" as the accelerator key, all in the same manner as "Find". However, it is the first occurrence of "c" that becoming underlined and not the second as in "Find". This is less meaningful as a mnemonic. What can I do about this? Peter T Sorry if I was unclear. I was referring to the "Find" window in Excel that is spawned either from Ctrl+F or via the Edit menu. That contains a "Match case" CheckBox but Microsoft have somehow managed to underscore the second "c", the one that starts the word "case", without needing to capitalise it. This is much more meaningful than underscoring the "c" in Match. All I want to do is the same thing. I fear that your answer "in VBA the accelerator will always find the first instance of the letter" is telling me that, in fact, I cannot do it in VBA unless I am prepared to capitalise the second "c". This is a pity because I was hoping to use the Microsoft style precisely. A negative answer is always useful, even if disappointing, because it will save me spending more time looking for a solution that doesn't exist. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accelerator
OK I follow now. The examples you refer to will use something like the "&"
prefix to define the accelerator, as I mentioned. Did you try the upper case C idea for your particular caption. Regards, Peter T "Dartmoor Graham" wrote in message ... "Peter T" wrote: In other programs you'd position the accelerator like this (in say VB) Match &case However in VBA the accelerator will always find the first instance of the letter. But maybe you could capitalise the C in Case and assign "C" as the accelerator. I have no idea what you mean by "same manner as Find" and "not the second as in "Find", so I might have misunderstood your objective. Regards, Peter T "Dartmoor Graham" <Dartmoor wrote in message ... I am using Excel2000. I have a UserForm containing a CheckBox with the caption "Match case" and I want to set "c" as the accelerator key, all in the same manner as "Find". However, it is the first occurrence of "c" that becoming underlined and not the second as in "Find". This is less meaningful as a mnemonic. What can I do about this? Peter T Sorry if I was unclear. I was referring to the "Find" window in Excel that is spawned either from Ctrl+F or via the Edit menu. That contains a "Match case" CheckBox but Microsoft have somehow managed to underscore the second "c", the one that starts the word "case", without needing to capitalise it. This is much more meaningful than underscoring the "c" in Match. All I want to do is the same thing. I fear that your answer "in VBA the accelerator will always find the first instance of the letter" is telling me that, in fact, I cannot do it in VBA unless I am prepared to capitalise the second "c". This is a pity because I was hoping to use the Microsoft style precisely. A negative answer is always useful, even if disappointing, because it will save me spending more time looking for a solution that doesn't exist. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accelerator
Hi Peter T
Yes, and I can confirm for the benefit of other readers that this does work. It's just disappointing that I can't make my UserForm look exactly like the Microsoft one. However, you have saved me the time of looking further so thank you for that. Dartmoor Graham PS I even tried deriving the first lowercase "c" from the Cyrillic alphabet by copying and pasting one from Word, but that just resulted in a question mark! "Peter T" wrote: OK I follow now. The examples you refer to will use something like the "&" prefix to define the accelerator, as I mentioned. Did you try the upper case C idea for your particular caption. Regards, Peter T "Dartmoor Graham" wrote in message ... "Peter T" wrote: In other programs you'd position the accelerator like this (in say VB) Match &case However in VBA the accelerator will always find the first instance of the letter. But maybe you could capitalise the C in Case and assign "C" as the accelerator. I have no idea what you mean by "same manner as Find" and "not the second as in "Find", so I might have misunderstood your objective. Regards, Peter T "Dartmoor Graham" <Dartmoor wrote in message ... I am using Excel2000. I have a UserForm containing a CheckBox with the caption "Match case" and I want to set "c" as the accelerator key, all in the same manner as "Find". However, it is the first occurrence of "c" that becoming underlined and not the second as in "Find". This is less meaningful as a mnemonic. What can I do about this? Peter T Sorry if I was unclear. I was referring to the "Find" window in Excel that is spawned either from Ctrl+F or via the Edit menu. That contains a "Match case" CheckBox but Microsoft have somehow managed to underscore the second "c", the one that starts the word "case", without needing to capitalise it. This is much more meaningful than underscoring the "c" in Match. All I want to do is the same thing. I fear that your answer "in VBA the accelerator will always find the first instance of the letter" is telling me that, in fact, I cannot do it in VBA unless I am prepared to capitalise the second "c". This is a pity because I was hoping to use the Microsoft style precisely. A negative answer is always useful, even if disappointing, because it will save me spending more time looking for a solution that doesn't exist. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Accelerator keys | Excel Programming | |||
Prevent control taking focus when accelerator key is used? | Excel Programming | |||
Option Button Accelerator Key | Excel Programming | |||
Accelerator Keys | Excel Programming | |||
appactivate sendkeys not working with accelerator | Excel Programming |