from the object browser in the VBE

Const vbShortDate = 2
Member of VBA.VbDateTimeFormat

so it is a member of the VBA type library.

However, it is a constant, not a data type, I don't see how you could
declare something as type vbShortDate. You would declare it as date and
format it as vbshortdate.

--
Regards,
Tom Ogilvy


"madeleine" wrote:

Hi

I'm hoping that someone can help me on this, I'm sure I must be going
mad, I'm trying to declare something as VbShortDate, I get told that I
need to include its type library, I can't actually find out what type
library it lives in.

Hopefully someone can tell me what box to tick in the references menu.

All help much appreciated.

Thanks

Madeleine