Code a data validation list in a spreadsheet control of a form

[robx2309]

Hi everyone,


I can't figure out how to code a data validation list on the active cell of a spreadsheet control within an Access form. I use the 11.0 spreadsheet, however I don't think the versions are so differents.
Anyway, I would be so glad if someone could help me because I do really need this code for a project.

Thanks in advance, and have a nice end of day

[NoellaG]

Hi,

Why don't you use an object frame with OLE class set to excel? This way you can use all Excel's features within the control (be sure to set the data properties enabled to yes and locked to false).

greetings
NG

[robx2309]

It sounds to be a good solution, as long as I can use all the features of Excel in my control.
Could you tell me how to do that ?

[NoellaG]

Hi,

• open the form in design view
• add a new unbound object frame control
• Choose as object type : Microsoft Excel Worksheet: you have now all excel toolbars to change the spreadsheet, if not doubble click the object.
• Click outside the object to return to the form design.
• If the users need to change the excel themselves, open the properties window of the control, and in the data tab set "Enabled" to yes and "Locked" to No.

Succes
NG

[robx2309]

Thanks, it finally works
And I had just a last question, do you know how can I do to handle the selectionChange event on that unbound object frame ?

EDIT : It's ok I found myself the answer. Thanks for your help