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

Since you have multiple things to do when chq is selected, rather than a
series of message or inputboxes I think I would create a second userform. So
when the user selects chq I would Show the 2nd form, take their input an all
the other questions at once, then have an "OK" button on the 2nd userform
that processes it all in one sub; I would also include a "CANCEL" button that
closes the 2nd form without any processing so they can go back to the main
form if they chose chq by mistake.

So 2nd form would probably have:
- Togglebuttons or radiobuttons with Yes/No answer with label "Have letter
and updated notes?"
- Same (toggle or radio buttons) with label "Cheque is going straight to
client?"
- textboxes for the address fields
- Then at bottom the "OK" and "Cancel" buttons with message "Press OK to
process this transaction, Cancel to return to main form"

Just my thoughts, can adopt and customize if you think it would meet your
needs.

--
- K Dales


"harpscardiff" wrote:


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

Im having problems with my list boxes:

Basically I what Ive got is
Check
DC
TT
Other

What Ive done so far is when they click on a option, it pops up with a
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", "TT
Reason")

Else

If Result = "CHQ" Then
Result = MsgBox("Please ensure you have: " & vbNewLine & ":: Letter"
& vbNewLine & ":: Updated Notes", vbExclamation + vbOKOnly, "Chq
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
Harps


--
harpscardiff
------------------------------------------------------------------------
harpscardiff's Profile: http://www.excelforum.com/member.php...o&userid=25960
View this thread: http://www.excelforum.com/showthread...hreadid=477867