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?

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 (E-Mail Removed)> wrote in
message news:8DFBBE78-484E-4237-8F58-(E-Mail Removed)...
>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" 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 (E-Mail Removed)> wrote in
> message news:8DFBBE78-484E-4237-8F58-(E-Mail Removed)...
> >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.

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" <(E-Mail Removed)> wrote in
message news:9E567A5A-5EB0-461D-9D79-(E-Mail Removed)...
>
>
> "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 (E-Mail Removed)> wrote in
>> message news:8DFBBE78-484E-4237-8F58-(E-Mail Removed)...
>> >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.

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" <(E-Mail Removed)> wrote in
> message news:9E567A5A-5EB0-461D-9D79-(E-Mail Removed)...
> >
> >
> > "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 (E-Mail Removed)> wrote in
> >> message news:8DFBBE78-484E-4237-8F58-(E-Mail Removed)...
> >> >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.
>
>
>