Now, I'm very new too all of this so please be gentle with me!

I am trying to create a User Form for people to book equipment through and I'm getting there but I'm finding a couple of things problematic:

The information my colleagues fill out on the User Form load into a spreadsheet when the order is submitted. This spreadsheet has separate columns for Equipment, Location, Shipping Date and Return Date.

I have the following code:

If chkItemX.Value = True And Range("D10").Value = "Company Name" Then
Range("F10").Value = txtEvent.Text
Range("G10").Value = txtShipping.Text
Range("H10").Value = txtReturn.Text
ElseIf chkItemX.Value = True And Range("D10").Value = "USA" Then
MsgBox "Item X Is Unavailable"
ElseIf chkItemX.Value = False Then
End If

Which is all very well and good if the equipment is either with us or in the USA however, what I really want to be able to say something like:

If chkItemX.Value = True And Range("D10").Value = "Company Name" Then
Range("F10").Value = txtEvent.Text
Range("G10").Value = txtShipping.Text
Range("H10").Value = txtReturn.Text
ElseIf chkItemX.Value = True And Range("D10").Value = "Anything Other Than Company Name" Then
MsgBox "Item X Is Unavailable"
ElseIf chkItemX.Value = False Then
End If

But I have no idea how to write the code for the bit 'Range("D10).Value = "Anything Other Than Company Name".....any ideas.....am I making any sense....?

Thank you for bearing with me,

L.