ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   RefEdit error (https://www.excelbanter.com/excel-programming/406220-refedit-error.html)

joeeng

RefEdit error
 
Every time I try to add a RefEdit control to a Modal form, I get the error
"Invalid Argument". Does anyone know why and how to avoid this?

Jon Peltier

RefEdit error
 
Just adding the control to a form? Not executing any code?

Quit Excel, then remove any .exd files, in fact any files, from these two
directories:

C:\Documents and Settings\<username\Local Settings\Temp
C:\Documents and Settings\<username\Application Data\Microsoft\Forms

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


"joeeng" wrote in message
...
Every time I try to add a RefEdit control to a Modal form, I get the error
"Invalid Argument". Does anyone know why and how to avoid this?




joeeng

RefEdit error
 
Thanks, that worked.

"Jon Peltier" wrote:

Just adding the control to a form? Not executing any code?

Quit Excel, then remove any .exd files, in fact any files, from these two
directories:

C:\Documents and Settings\<username\Local Settings\Temp
C:\Documents and Settings\<username\Application Data\Microsoft\Forms

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


"joeeng" wrote in message
...
Every time I try to add a RefEdit control to a Modal form, I get the error
"Invalid Argument". Does anyone know why and how to avoid this?





Arne

RefEdit error
 
Funny, I had problems using RefEdit Controls (it seemed to me that these
problems occurred mainly when I put them inside frames), and the above
solutions seems to work for in that case as well. So, thanks.

Jon Peltier

RefEdit error
 
Putting RefEdits in Frames or on MultiPage controls is a recipe for
disaster.

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


"Arne" wrote in message
...
Funny, I had problems using RefEdit Controls (it seemed to me that these
problems occurred mainly when I put them inside frames), and the above
solutions seems to work for in that case as well. So, thanks.





All times are GMT +1. The time now is 02:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com