In the process of moving from an xla to a dll I need to use the ref
edit control in a VB6 form (which is not possible: http://support.microsoft.com/kb/q281542/
).

Searching in this forum saw that it was an old problem. Wonder if
somebody can spare me the time to "build"a work around using a: form,
a text box, a command button and inputbox...

Cheers
Mika

Hi Mika

If you can access an Excel application.inputbox then see Jon's solution here
http://peltiertech.com/WordPress/ref...l-alternative/

HTH. Best wishes Harald

"Mika" wrote in message
...
In the process of moving from an xla to a dll I need to use the ref
edit control in a VB6 form (which is not possible:
http://support.microsoft.com/kb/q281542/
).

Searching in this forum saw that it was an old problem. Wonder if
somebody can spare me the time to "build"a work around using a: form,
a text box, a command button and inputbox...

Cheers
Mika

On Nov 21, 1:36*pm, "Harald Staff" wrote:
Hi Mika

If you can access an Excel application.inputbox then see Jon's solution herehttp://peltiertech.com/WordPress/refedit-control-alternative/

HTH. Best wishes Harald

"Mika" wrote in message

...

In the process of moving from an xla to a dll I need to use the ref
edit control in a VB6 form (which is not possible:
http://support.microsoft.com/kb/q281542/
).

Searching in this forum saw that it was an old problem. Wonder if
somebody can spare me the time to "build"a work around using a: form,
a text box, a command button and inputbox...

Cheers
Mika

Hi Harald: absolutely wonderful !!! Thanks, by the way I recommend to
read Peltier's artcicl: a lot of useful information for those using
the ref edit control as it is.