Fill list validation without range

**Jivo** · 06-22-2009, 07:34 AM

Hi all,

I'm trying to fill a list with some hard values. When I use the macro recorder it adds formula="choice 1;choice 2; etc", these are all separate values in the list. However if I use this within a macro I only have one option with all three values combined

Any ideas how I can enter separate values throug a macro? thanks.

BR,

Jivo

**DonkeyOte** · 06-22-2009, 07:42 AM

Try switching the ; to a ,

**royUK** · 06-22-2009, 07:51 AM

I'm not sure what you mean, adding a list as dat validation would require an array of values.

Please Login or Register  to view this content.

I can't really see why you need VBA to do this

**Jivo** · 06-22-2009, 08:43 AM

Mmm, the problem appears to be sorted when the workbook is reopened... It's probably a small error in the updating of a list.

To clarify the issue:
In an active workbook the macro filled validation displays:
-Yes; No; OK

while it should be:
- Yes
- No
- OK

regards,

Ivo