View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Mika Mika is offline
external usenet poster
 
Posts: 48
Default How to use MS Flex Grid in Excel vba form

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.