msFlexGrid on a Frame on a worksheet

[tkt2ride]

I am trying to place a msFlexgrid on a worksheet. It cannot be placed directly on the screen, so I tried puuting a frame on the sheet and then putting the msFlesGrid on the frame. The problem is I cannot reference it in code.
Example:
With sheet1.frame1.???????
It doesn't show up in any category after....frame1.
Is this possible to do it this way or am I going to have to do it another way or forget it?
Thanks,
Jim

 

[nath]

Hi Jim,

I'd put it on a form and call the form from the spreadsheet. I don't think you can put these kind of complicated objects directly on the spreadsheet.

If I'm wrong, guys, let me know, I'm interested!

Nath

 

[SkipVought]

Hi,
Try laying down an Image object and placing the MSFlexGrid on the Image Object. MSFlexGrid1_Click() et al shows up on the worksheet object, at least in Excel 2002
Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com