trouble with code

gummybear · #1 04-19-2018, 12:26 PM

Quote:

Originally Posted by NoSparks

You need to deal with Term prior to getting to this point in your code.

This should give an idea...

Code:

Sub Testing()

Dim Term As Variant

'don't know how your variable is being assigned so...
    Term = " "
'check if its a date
    If Not IsDate(Term) Then
        'assign a date
        Term = DateSerial(1900, 1, 1)
    End If
    
'message box to show what Term currently is
    MsgBox Term

End Sub

I ran your code and it answered my question. Thank you so much.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Trouble with me animations	Halesowenmum	PowerPoint	5	11-21-2017 04:14 AM
Trouble with Hyperlinks	DanielMcCrea	Word	1	09-27-2017 02:35 PM
VBA Code to search for field codes with certain text before the Field code and to change style	welcometocandyland	Word VBA	4	02-08-2017 06:53 PM
Parsing Code Macro Trouble!	Snaybot	Excel Programming	1	05-15-2016 08:33 PM
I'm having trouble doing these tasks	jackmackfack	Word	4	02-19-2015 06:46 PM