|
Changing appearance of RefEdit control
Hi All.
following an unanswered post in this group - http://groups.google.com/group/micro... 9a1f87b421834 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 |
Changing appearance of RefEdit control
It already matches it for me.
-- Regards, Tom Ogilvy "Ofek Shilon" wrote in message s.com... Hi All. following an unanswered post in this group - http://groups.google.com/group/micro... 9a1f87b421834 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 |
Changing appearance of RefEdit control
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" wrote in message s.com... Hi All. following an unanswered post in this group - http://groups.google.com/group/micro... 9a1f87b421834 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 |
Changing appearance of RefEdit control
When it collapses during a selection, it looks identical to me. A red and
blue Icon. Yours behave differently? -- Regards, Tom Ogilvy "Jon Peltier" wrote in message ... 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" wrote in message s.com... Hi All. following an unanswered post in this group - http://groups.google.com/group/micro... 9a1f87b421834 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 |
Changing appearance of RefEdit control
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" wrote in message ... When it collapses during a selection, it looks identical to me. A red and blue Icon. Yours behave differently? -- Regards, Tom Ogilvy "Jon Peltier" wrote in message ... 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" wrote in message s.com... Hi All. following an unanswered post in this group - http://groups.google.com/group/micro... 9a1f87b421834 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 |
Changing appearance of RefEdit control
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" wrote in message ... 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" wrote in message ... When it collapses during a selection, it looks identical to me. A red and blue Icon. Yours behave differently? -- Regards, Tom Ogilvy "Jon Peltier" wrote in message ... 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" wrote in message s.com... Hi All. following an unanswered post in this group - http://groups.google.com/group/micro... 9a1f87b421834 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 |
Changing appearance of RefEdit control
On Mar 6, 5:39 pm, "Jon Peltier"
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" wrote in message ... 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" wrote in message ... When it collapses during a selection, it looks identical to me. A red and blue Icon. Yours behave differently? -- Regards, Tom Ogilvy "Jon Peltier" wrote in message ... 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" wrote in message oups.com... 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 |
| All times are GMT +1. The time now is 03:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com