Syntax eror?

[ddub25]

Sub Ent1_1BrUp1stSt()
Dim Conditions1 As String
Dim Conditions2 As String
Dim ConditionsAll As String

Conditions1 = Range("E94").Text
Conditions2 = Range("H93").Text

ConditionsAll = Conditions1 & Conditions2

MessageBox.Show (ConditionsAll)
End Sub

I was expecting this code to output the text in Conditions1 and Conditions2 in a message. E94 = True and H93 = True

I get a Run-time error '424': Object required

 

[dmt32]

Hi,

change this line

MessageBox.Show (ConditionsAll)

to this

MsgBox (ConditionsAll)

Dave

 

[ddub25]

Thanks, I didn't think there was too much wrong. Problem solved