How to display a message box if a box is selected

gmayor · #1 12-11-2015, 09:54 PM

Absolutely

Code:

Private Sub cmdOk_Click()
    FillBM "FirstName", Me.txtFirstName.Text
    Unload Me
End Sub

rosscortb · #2 12-16-2015, 08:04 AM

Hi Graham,

Thanks for your help.

Got another question.

I have the following code and when the check box is selected the text is added to the doc and what I want to know is there a way of entering in the relocation amount, with say, a pop up input box at the end?

Sub chkRelocationAssistance_Click()
If Me.chkRelocationAssistance = True Then
FillBM "Relocation1", "You are eligible for financial assistance through the Relocation Policy, a copy of which is enclosed. On receipt please will you sign Appendix 1,2 and 3 policy and pass to your manager on your first day. The assistance will be capped at £; which will be tax free in line with HMRC(Her Majesty's Revenue and Customs) regulations."
FillBM "Relocation2", "You have been offered relocation assistance based on your particular circumstances and for this reason, we ask that you do not discuss this matter with your work colleagues and your absolute discretion is appreciated."
FillBM "Relocation3", "Relocation Policy"
Else
FillBM "Relocation1", ""
FillBM "Relocation2", ""
FillBM "Relocation3", ""
End If
End Sub

Thanks

Ross

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Problem opening Outlook Today. Error Message: Cannot display the folder. Cannot find this file. Veri	atwnsw	Outlook	0	11-01-2015 05:05 PM
How to Display Arrow for Drop Down Lists in Message Body	hue2	Outlook	0	03-20-2015 12:24 PM
Pivot Table Question- Can the table display in the order the boxes were checked/selected?	blackjack	Excel	0	09-13-2014 08:57 PM
Option Button selected will display text	ksigcajun	Word VBA	7	07-14-2014 09:31 AM
Display paragraph of text based on value selected in combo	WordWaza	Word	0	08-09-2013 06:30 AM