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?

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?

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?

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.

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.