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.
Bookmarks