C coley Coley Local time Today, 21:22 Joined Feb 22, 2005 Messages 39 Mar 24, 2005 #1 Hi I am using the VBYes/No function, what do I need to write to be able to populate a designated field/text box with either Yes or No from what was clicked. Keith
Hi I am using the VBYes/No function, what do I need to write to be able to populate a designated field/text box with either Yes or No from what was clicked. Keith
Mile-O Back once again... Local time Today, 21:22 Joined Dec 10, 2002 Messages 11,310 Mar 24, 2005 #2 coley said: I am using the VBYes/No function Click to expand... Can you further explain what you mean? There is no Yes/No function in VB.
coley said: I am using the VBYes/No function Click to expand... Can you further explain what you mean? There is no Yes/No function in VB.
C coley Coley Local time Today, 21:22 Joined Feb 22, 2005 Messages 39 Mar 24, 2005 #3 vbYesNo this is what i have got userResponse3 = MsgBox("Has the project been sent to ITRM for an Estimate?", vbYesNo, "ITRM?") If userResponse3 = vbYes Then What do i put next, i need this to happen, if the user clicks 'yes' then Yes is to populate in the field, clicks 'No' No populates? yell if you need more keith
vbYesNo this is what i have got userResponse3 = MsgBox("Has the project been sent to ITRM for an Estimate?", vbYesNo, "ITRM?") If userResponse3 = vbYes Then What do i put next, i need this to happen, if the user clicks 'yes' then Yes is to populate in the field, clicks 'No' No populates? yell if you need more keith
S Shadez Registered User. Local time Today, 21:22 Joined Jan 20, 2003 Messages 192 Mar 24, 2005 #4 Code: If MsgBox("Has the project been sent to ITRM for an Estimate?", vbYesNo, "ITRM?") = vbYes Then MyTextBox = "Yes" Else MyTextBox = "No" end if Last edited: Mar 24, 2005
Code: If MsgBox("Has the project been sent to ITRM for an Estimate?", vbYesNo, "ITRM?") = vbYes Then MyTextBox = "Yes" Else MyTextBox = "No" end if