How can I get a grid on a form?

[jrice84]

I'm still using Excel 2000 and I'm trying to put a grid on a form. I'm basically using Excel just to store my data and using VBA forms to interface with the user. I have one instance where I'm trying to dispaly a 5 day calendar and either a flexgrid or a spreadsheet control would work perfectly. From what I've seen on-line, it looks like a flexgrid is not the way to go. When I try to add a spreadsheet control, I get the error message "The subject is not trusted for the specified action". I've looked around but I can't figure out how to get around this problem. What the heck should I do?

 

[MajP]

can you provide a little more detail of the display you desire? Also why do you think a flexgrid would not support your desired display, but a spreadsheet would? That may help define the requirement. Maybe you could draw notional display in word or powerpoint and post that. I could think of lots of controls from flexgrids to multiple listboxes to textboxes, but do not know the desired effect.

 

[jontout]

If the 5 day calendar needs to be dynamic, why not use the Calendar Control? Having re-read the question, would Access not be a better tool for the job?

 

[jrice84]

I'm just trying to show 5 days so the user can easily see the week, so the calendar control won't work. I wanted to have a grid with time from 8:00 to 5:00 along the left hand side and days of the week across the top and then add appointments as needed. The user then can select any of the entries to access the data for that appointment. I saw somewhere that it looks like a flexgrid can be a pain to work with. I don't have the flexgrid on my tool box and I don't see it under additional controls. I just keep getting the "The subject is not trusted for the specified action" error when I try to add a spreadsheet control and can'r get around it.

 

[fumei]

Do a search here on Flexgrid trust. It was a huge discussion.

Gerry

 

[MajP]

Is this some kind of school project, to me this just sounds bizarre.

First you are storing database type information in a spreadsheet. Then you want to build a vb front end with a spreadsheet control to display database type information that is already in a spreadsheet.

Why would you not use Access to do this? Which can do all of this natively. I can not see a spreadsheet as a appropriate datasource for appointment information. It can be done and you can use Excel as a word processor. But use a database to do database stuff and a spreadsheet to do spreadsheet stuff. If you need a vb front end, I still think the back end is either Access or sql server.

 

[fumei]

I was originally commenting on the flex grid issue, but I have to agree that it does sounds a bit strange to put that much effort into something like this. However, perhaps there is a valid reason I am not catching.

Gerry