id="info"

General discussion

Locked

Excel Data Validation

By David.Jackson ·
I have been trying to set up Excel cell data validation with drop down lists from VBA Behind an Access application. I can do it with reference to a simple (named or otherwise) range defining a list, but not with a validation formula containing functions like OFFSET.

I have also tried copying the cell validation, but it only seems possible in the same workbook.

Anyone have any suggestions on how I can set up a drop down lists in cells from Access VBA?

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel Validation via Access VBA

by dorothy.nishimoto In reply to Excel Data Validation

Hello David. Unfortunately, I don't have a solution. I just have a question. I've been trying to do this myself and was wondering if you would be so kind as to share your code on how you actually got your data validation to work in Excel via Access. I don't need the complexity that you need. I just need to get the list to reference two cells in Excel. Any help would be greatly appreciated. Thanks!

Dorothy

Back to Software Forum
1 total post (Page 1 of 1)  

Software Forums