Hi guys

I have VB 6, and need to use the Ms Flex Grid control on a VBA form
within Excel.

However the incorporation of the control into the form is rejected
with the message "unsafe..." which normally occurs if you dont have
the license for it (or don't have VB 6 installed) which is not my
case.

In the forms in VB 6 environment, I don't have any problem.

Does anybody know how to use (load) the cotrol on the Excel form?

Mika was thinking very hard :
Hi guys

I have VB 6, and need to use the Ms Flex Grid control on a VBA form
within Excel.

However the incorporation of the control into the form is rejected
with the message "unsafe..." which normally occurs if you dont have
the license for it (or don't have VB 6 installed) which is not my
case.

In the forms in VB 6 environment, I don't have any problem.

Does anybody know how to use (load) the cotrol on the Excel form?

When the userform is active in design view, right-click the Toolbox and
you'll be able to add additional controls. It will, of course, be
necessary to distribute (and register) the control with your vba
project in order for it to work on other machines.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

On Nov 3, 5:59*pm, GS wrote:
Mika was thinking very hard :

Hi guys

I have VB 6, and need to use the Ms Flex Grid control on a VBA form
within Excel.

However the incorporation of the control into the form is rejected
with the message "unsafe..." which normally occurs if you dont have
the license for it (or don't have VB 6 installed) which is not my
case.

In the forms in VB 6 environment, I don't have any problem.

Does anybody know how to use (load) the cotrol on the Excel form?

When the userform is active in design view, right-click the Toolbox and
you'll be able to add additional controls. It will, of course, be
necessary to distribute (and register) the control with your vba
project in order for it to work on other machines.

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

GS, I didn't explain it clearly.
There is not problem to add the control to the toolbox as you
describe. The error appears when I try to put such control FROM the
toolbox into the Form. Then, it is not accepted.

It happens that Mika formulated :
On Nov 3, 5:59*pm, GS wrote:
Mika was thinking very hard :

Hi guys

I have VB 6, and need to use the Ms Flex Grid control on a VBA form
within Excel.

However the incorporation of the control into the form is rejected
with the message "unsafe..." which normally occurs if you dont have
the license for it (or don't have VB 6 installed) which is not my
case.

In the forms in VB 6 environment, I don't have any problem.
Does anybody know how to use (load) the cotrol on the Excel form?

When the userform is active in design view, right-click the Toolbox and
you'll be able to add additional controls. It will, of course, be
necessary to distribute (and register) the control with your vba
project in order for it to work on other machines.

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

GS, I didn't explain it clearly.
There is not problem to add the control to the toolbox as you
describe. The error appears when I try to put such control FROM the
toolbox into the Form. Then, it is not accepted.

I see. I don't get that when I draw the control on a userform (or
drag/drop it there). It seems to work just fine for me. Maybe you could
provide more info like which version of Excel you're working in and the
version of MSFlexGrid.ocx you're trying to use.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

"Mika" wrote in message
...

I have VB 6, and need to use the Ms Flex Grid control on a VBA form
within Excel.

However the incorporation of the control into the form is rejected
with the message "unsafe..." which normally occurs if you dont have
the license for it (or don't have VB 6 installed) which is not my
case.

In the forms in VB 6 environment, I don't have any problem.

Hi Mika

Userforms are not compiled like exe files are. To use a control on a
userform, the user needs a license to run the control in "design mode" -here
meaning a valid Visual Studio 6 installation.

So in short, you can't do this.

Best wishes Harald

On Nov 3, 9:15*pm, "Harald Staff" wrote:
"Mika" wrote in message

...

I have VB 6, and need to use the Ms Flex Grid control on a VBA form
within Excel.

However the incorporation of the control into the form is rejected
with the message "unsafe..." which normally occurs if you dont have
the license for it (or don't have VB 6 installed) which is not my
case.

In the forms in VB 6 environment, I don't have any problem.

Hi Mika

Userforms are not compiled like exe files are. To use a control on a
userform, the user needs a license to run the control in "design mode" -here
meaning a valid Visual Studio 6 installation.

So in short, you can't do this.

Best wishes Harald


Just for the records, in case somebody got the same problem, I was
able to solve it in the most unusual way:

- First: yes, I do have a legal version of VB 6 installed, and as I
said I can work in VB and the Flex grid without problem.

I found that in another excel form my Common dialog control stopped
working as well, getting the error; "Class not registered...", on top
of that, another control used: Tree list, had the same error.

Therefore I re-registered both controls, with regserv32, and voila !
the MS FlexGrid began to work! I didn't have to register the MS
FlexGrid control.

What is the reason ?. I have no clue.

"Mika" skrev i melding
...
Just for the records, in case somebody got the same problem, I was
able to solve it in the most unusual way:

- First: yes, I do have a legal version of VB 6 installed, and as I
said I can work in VB and the Flex grid without problem.

Ah good. For the records, sorry I misunderstood your problem. It usually is:
A userform like that will not run on other computers that doesn't have VB6,
even when the controls are properly installed and registered.

Best wishes Harald