Hi All.

following an unanswered post in this group -
http://groups.google.com/group/micro...59a1f87b421834

I wish to change the RefEdit look&feel to match the familiar built-in
control in excel - i.e., to convert the 'underscore' icon at the right
to the red/blue one.
How can this be done? Perhaps there's some undocumented property
doing that? Perhaps what i'm looking for is a different control
altogether?

I'm somewhat of a newbie to VBA, but this may be untrivial, as this
older post -
http://www.dailydoseofexcel.com/arch...#comment-21422

- went unanswered too.
I'm well aware of the bugs-aura surrounding RefEdit, but my usage is a
very simple one (on the UserForm itself, no other simultaneous forms,
etc.). any advice would be much appreciated!


Ofek

It already matches it for me.

--
Regards,
Tom Ogilvy

"Ofek Shilon" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi All.
>
> following an unanswered post in this group -
> http://groups.google.com/group/micro...59a1f87b421834
>
> I wish to change the RefEdit look&feel to match the familiar built-in
> control in excel - i.e., to convert the 'underscore' icon at the right
> to the red/blue one.
> How can this be done? Perhaps there's some undocumented property
> doing that? Perhaps what i'm looking for is a different control
> altogether?
>
> I'm somewhat of a newbie to VBA, but this may be untrivial, as this
> older post -
> http://www.dailydoseofexcel.com/arch...#comment-21422
>
> - went unanswered too.
> I'm well aware of the bugs-aura surrounding RefEdit, but my usage is a
> very simple one (on the UserForm itself, no other simultaneous forms,
> etc.). any advice would be much appreciated!
>
>
> Ofek
>

I'm not sure what Tom's referring to. The RefEdit looks different than the
data entry box found in native Excel dialogs. The only thing you might be
able to do is place an image control over the RefEdit's button, and place a
bitmap of the native entry box button in the image control.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Ofek Shilon" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi All.
>
> following an unanswered post in this group -
> http://groups.google.com/group/micro...59a1f87b421834
>
> I wish to change the RefEdit look&feel to match the familiar built-in
> control in excel - i.e., to convert the 'underscore' icon at the right
> to the red/blue one.
> How can this be done? Perhaps there's some undocumented property
> doing that? Perhaps what i'm looking for is a different control
> altogether?
>
> I'm somewhat of a newbie to VBA, but this may be untrivial, as this
> older post -
> http://www.dailydoseofexcel.com/arch...#comment-21422
>
> - went unanswered too.
> I'm well aware of the bugs-aura surrounding RefEdit, but my usage is a
> very simple one (on the UserForm itself, no other simultaneous forms,
> etc.). any advice would be much appreciated!
>
>
> Ofek
>

When it collapses during a selection, it looks identical to me. A red and
blue Icon. Yours behave differently?

--
Regards,
Tom Ogilvy



"Jon Peltier" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I'm not sure what Tom's referring to. The RefEdit looks different than the
> data entry box found in native Excel dialogs. The only thing you might be
> able to do is place an image control over the RefEdit's button, and place
> a bitmap of the native entry box button in the image control.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> http://PeltierTech.com
> _______
>
>
> "Ofek Shilon" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Hi All.
>>
>> following an unanswered post in this group -
>> http://groups.google.com/group/micro...59a1f87b421834
>>
>> I wish to change the RefEdit look&feel to match the familiar built-in
>> control in excel - i.e., to convert the 'underscore' icon at the right
>> to the red/blue one.
>> How can this be done? Perhaps there's some undocumented property
>> doing that? Perhaps what i'm looking for is a different control
>> altogether?
>>
>> I'm somewhat of a newbie to VBA, but this may be untrivial, as this
>> older post -
>> http://www.dailydoseofexcel.com/arch...#comment-21422
>>
>> - went unanswered too.
>> I'm well aware of the bugs-aura surrounding RefEdit, but my usage is a
>> very simple one (on the UserForm itself, no other simultaneous forms,
>> etc.). any advice would be much appreciated!
>>
>>
>> Ofek
>>
>
>

My bad. I reread the post, tested the refedit and see the OP is looking at
the difference before the selection. I was under the mistaken impression
they were the same as well. Sorry for the bad information.

--
Regards,
Tom Ogilvy

"Tom Ogilvy" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> When it collapses during a selection, it looks identical to me. A red and
> blue Icon. Yours behave differently?
>
> --
> Regards,
> Tom Ogilvy
>
>
>
> "Jon Peltier" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> I'm not sure what Tom's referring to. The RefEdit looks different than
>> the data entry box found in native Excel dialogs. The only thing you
>> might be able to do is place an image control over the RefEdit's button,
>> and place a bitmap of the native entry box button in the image control.
>>
>> - Jon
>> -------
>> Jon Peltier, Microsoft Excel MVP
>> Tutorials and Custom Solutions
>> http://PeltierTech.com
>> _______
>>
>>
>> "Ofek Shilon" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> Hi All.
>>>
>>> following an unanswered post in this group -
>>> http://groups.google.com/group/micro...59a1f87b421834
>>>
>>> I wish to change the RefEdit look&feel to match the familiar built-in
>>> control in excel - i.e., to convert the 'underscore' icon at the right
>>> to the red/blue one.
>>> How can this be done? Perhaps there's some undocumented property
>>> doing that? Perhaps what i'm looking for is a different control
>>> altogether?
>>>
>>> I'm somewhat of a newbie to VBA, but this may be untrivial, as this
>>> older post -
>>> http://www.dailydoseofexcel.com/arch...#comment-21422
>>>
>>> - went unanswered too.
>>> I'm well aware of the bugs-aura surrounding RefEdit, but my usage is a
>>> very simple one (on the UserForm itself, no other simultaneous forms,
>>> etc.). any advice would be much appreciated!
>>>
>>>
>>> Ofek
>>>
>>
>>
>
>

I only looked at the initial appearance. I read your first reply to my post
(didn't see the second) and had to rebuild a sample to try it. I didn't know
they looked the same in the collapsed state, so I guess we both learned
something.

In any case, I don't think it's worth trying to mimic the appearance of the
RefEdit.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Tom Ogilvy" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> My bad. I reread the post, tested the refedit and see the OP is looking
> at the difference before the selection. I was under the mistaken
> impression they were the same as well. Sorry for the bad information.
>
> --
> Regards,
> Tom Ogilvy
>
> "Tom Ogilvy" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> When it collapses during a selection, it looks identical to me. A red
>> and blue Icon. Yours behave differently?
>>
>> --
>> Regards,
>> Tom Ogilvy
>>
>>
>>
>> "Jon Peltier" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> I'm not sure what Tom's referring to. The RefEdit looks different than
>>> the data entry box found in native Excel dialogs. The only thing you
>>> might be able to do is place an image control over the RefEdit's button,
>>> and place a bitmap of the native entry box button in the image control.
>>>
>>> - Jon
>>> -------
>>> Jon Peltier, Microsoft Excel MVP
>>> Tutorials and Custom Solutions
>>> http://PeltierTech.com
>>> _______
>>>
>>>
>>> "Ofek Shilon" <(E-Mail Removed)> wrote in message
>>> news:(E-Mail Removed)...
>>>> Hi All.
>>>>
>>>> following an unanswered post in this group -
>>>> http://groups.google.com/group/micro...59a1f87b421834
>>>>
>>>> I wish to change the RefEdit look&feel to match the familiar built-in
>>>> control in excel - i.e., to convert the 'underscore' icon at the right
>>>> to the red/blue one.
>>>> How can this be done? Perhaps there's some undocumented property
>>>> doing that? Perhaps what i'm looking for is a different control
>>>> altogether?
>>>>
>>>> I'm somewhat of a newbie to VBA, but this may be untrivial, as this
>>>> older post -
>>>> http://www.dailydoseofexcel.com/arch...#comment-21422
>>>>
>>>> - went unanswered too.
>>>> I'm well aware of the bugs-aura surrounding RefEdit, but my usage is a
>>>> very simple one (on the UserForm itself, no other simultaneous forms,
>>>> etc.). any advice would be much appreciated!
>>>>
>>>>
>>>> Ofek
>>>>
>>>
>>>
>>
>>
>
>

On Mar 6, 5:39 pm, "Jon Peltier" <jonxlmv...@SPAMpeltiertech.com>
wrote:
> I only looked at the initial appearance. I read your first reply to my post
> (didn't see the second) and had to rebuild a sample to try it. I didn't know
> they looked the same in the collapsed state, so I guess we both learned
> something.
>
> In any case, I don't think it's worth trying to mimic the appearance of theRefEdit.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutionshttp://PeltierTech.com
> _______
>
> "Tom Ogilvy" <twogi...@msn.com> wrote in message
>
> news:(E-Mail Removed)...
>
>
>
>
>
> > My bad. I reread the post, tested therefeditand see the OP is looking
> > at the difference before the selection. I was under the mistaken
> > impression they were the same as well. Sorry for the bad information.
>
> > --
> > Regards,
> > Tom Ogilvy
>
> > "Tom Ogilvy" <twogi...@msn.com> wrote in message
> >news:(E-Mail Removed)...
> >> When it collapses during a selection, it looks identical to me. A red
> >> and blue Icon. Yours behave differently?
>
> >> --
> >> Regards,
> >> Tom Ogilvy
>
> >> "Jon Peltier" <jonxlmv...@SPAMpeltiertech.com> wrote in message
> >>news:(E-Mail Removed)...
> >>> I'm not sure what Tom's referring to. TheRefEditlooks different than
> >>> the data entry box found in native Excel dialogs. The only thing you
> >>> might be able to do is place an image control over theRefEdit'sbutton,
> >>> and place a bitmap of the native entry box button in the image control.
>
> >>> - Jon
> >>> -------
> >>> Jon Peltier, Microsoft Excel MVP
> >>> Tutorials and Custom Solutions
> >>>http://PeltierTech.com
> >>> _______
>
> >>> "OfekShilon" <o...@simbionix.com> wrote in message
> >>>news:(E-Mail Removed)...
> >>>> Hi All.
>
> >>>> following an unanswered post in this group -
> >>>>http://groups.google.com/group/micro...rogramming/bro...
>
> >>>> I wish to change theRefEditlook&feel to match the familiar built-in
> >>>> control in excel - i.e., to convert the 'underscore' icon at the right
> >>>> to the red/blue one.
> >>>> How can this be done? Perhaps there's some undocumented property
> >>>> doing that? Perhaps what i'm looking for is a different control
> >>>> altogether?
>
> >>>> I'm somewhat of a newbie to VBA, but this may be untrivial, as this
> >>>> older post -
> >>>>http://www.dailydoseofexcel.com/arch...king-in-refedi...
>
> >>>> - went unanswered too.
> >>>> I'm well aware of the bugs-aura surroundingRefEdit, but my usage is a
> >>>> very simple one (on the UserForm itself, no other simultaneous forms,
> >>>> etc.). any advice would be much appreciated!
>
> >>>>Ofek



Thanks for the tips. perhaps i will try to hack a RefEdt substitute
myself, but that being more of a project than i thought it would
probably have to wait a while.


Ofek