Changing appearance of RefEdit control

[Ofek Shilon]

Hi All.

following an unanswered post in this group -
http://groups.google.com/group/micr...nk=gst&q=Refedit+look&rnum=2#ab59a1f87b421834

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/archives/2004/07/12/working-in-refedit-controls/#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

 

[Tom Ogilvy]

It already matches it for me.

 

[Jon Peltier]

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

 

[Tom Ogilvy]

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

 

[Tom Ogilvy]

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.

 

[Jon Peltier]

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

 

[Ofek Shilon]

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

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