format export excel

[matrixknow]

I do an export from access to excel and I do some formatting on the data in excel. It works.
I wonder, one field in the excel sheet should be a listbox (with a fixed content). Has somenone an idea on how to write this (example code).

 

[AlexCuse]

You may want to check out the VBA Forum (not Access VBA).

forum707

Hope it helps,

ALex



Ignorance of certain subjects is a great part of wisdom

 

[SkipVought]

Hi,

Check out Data > Validation -- LISTBOX feature.

Skip,

_{To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white]}