Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I've read many such claims about problems with the RefEdit control --
too many to ignore. So, yes, the OP should be careful. Nonetheless, I have used Refedits quite successfully through the years. The only problem I've had with it has been in modeless userforms (and COM Add-ins); both problems/limitations are documented in the MS KB. There are other documented problems with refedit. For more search support.microsoft.com for 'refedit' (w/o the quotes). Someone recently told me about the problem with a frame (and a multi- page). I've also read problems attributed to multiple refedits on the same form and refedits that overlap other controls. However, I've been using refedits in a frame for years and have tested the other problem scenarios along the way but have been unable to reproduce the problem. One guess -- and this is strictly speculative -- is the use of RefEdit event procedures (or event procedures that affect a refedit control). Until working out a way to use refedits in modeless userforms, I have never used a refedit_xxx procedure (haven't seen any value to one). It would be interesting to see if the use of such procedures can be linked to the reported problems. Bottom line: just because I've been unable to reproduce reported problems with it doesn't mean it is 100% safe to use. Just that I have been happy with it. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... be careful though, it can take a bit of care as to where and how to use it. For instance, never put it in a frame. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Selector disappears | Excel Discussion (Misc queries) | |||
Multiple product selector | Excel Worksheet Functions | |||
Equation Selector | Excel Discussion (Misc queries) | |||
selector | Excel Worksheet Functions | |||
selector | Excel Worksheet Functions |