ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Emulating Ref Edit in VB6 (https://www.excelbanter.com/excel-programming/443924-emulating-ref-edit-vb6.html)

Mika

Emulating Ref Edit in VB6
 
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

Harald Staff[_2_]

Emulating Ref Edit in VB6
 
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



Mika

Emulating Ref Edit in VB6
 
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.


All times are GMT +1. The time now is 01:52 AM.

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