I’ve got a form, which ones completed transfers the data onto th
spreadsheet. Its mainly made up of text boxes.

I’m having problems with my list boxes:

Basically I what I’ve got is
Check
DC
TT
Other

What I’ve done so far is when they click on a option, it pops up with
msgbox asking them to do something:


Private Sub cboPaymentMethod_Click()
Dim Result As String

Result = cboPaymentMethod.Value

If Result = "TT" Then
txtTTReason.Value = InputBox("Please state reason for TT", "T
Reason")

Else

If Result = "CHQ" Then
Result = MsgBox("Please ensure you have: " & vbNewLine & ":: Letter
& vbNewLine & ":: Updated Notes", vbExclamation + vbOKOnly, "Ch
Requirements")


What I need to happen is if chq is selected then,
1. Ask if they have got the letter and updated notes
2. Ask if the chq is going straight to the client
3. if yes then fill autofill the address fields (which are textboxes)
4. else exit sub


Just can get my head round it….any ideas?

Cheers
Harp

--
harpscardif
-----------------------------------------------------------------------
harpscardiff's Profile: http://www.excelforum.com/member.php...fo&userid=2596
View this thread: http://www.excelforum.com/showthread.php?threadid=47786