"type mismatch" error

13 views
Skip to first unread message

mary.st...@gmail.com

unread,
Oct 20, 2022, 8:35:22 AM10/20/22
to SKYIndexUsers
Hi, Everyone.

What does the "type mismatch" error message mean?

Thank you,

Mary

Nigel D'Auvergne

unread,
Oct 20, 2022, 11:10:34 AM10/20/22
to SKYIndexUsers

There was a protracted discussion on this some time ago.

The result was that no-one knows, but it has no effect.

‘Keep calm and carry on’.

 

Nigel

--
You received this message because you are subscribed to the Google Groups "SKYIndexUsers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to skyindexuser...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/skyindexusers/32e9ad57-c5f8-4d11-a24a-1c349a5755e0n%40googlegroups.com.

barry.c...@indexbase.co.uk

unread,
Oct 20, 2022, 12:36:35 PM10/20/22
to ni...@nigeldauvergne.co.uk, SKYIndexUsers

A type mismatch error can be caused when a numeric carriable is assigned a string value.

An example is the VBA macro below. It compiles because type checking is not enforced but causes a runtime error.

Sub Mismatch()

'

' Mismatch Macro

'

Dim i As Long

i = "abc"

End Sub

 

Barry Campbell

www.indexbase.co.uk

Reply all
Reply to author
Forward
0 new messages