Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

append values from option boxes to make word

Status
Not open for further replies.

newbee2

Technical User
Apr 21, 2002
85
0
0
Greetings,
I have 11 option boxes , Series,B,T,W,D,V,E,X,C,K,A on a form.
I would like to take each of the values made by a selected checkbox in each of the option boxes and create a word from them in a feild or text box somewhere on the form in the shape of

375.203.1.3.0.2 etc.

When the form prints with the option boxes showing, it prints the combined result word also. So that the form shows how the word was made up as a check.

What please is the VBA code or method to do this.

Thanks in advance
Best regrads
Bill
 
Hello:

This would do it:

Private Sub cmdCombine_Click()
Dim Str As String
Str = Text0 & "." & Text1 & "." & Text2
MsgBox Str
Text3 = Str

End Sub

Three text boxes named text0, text1 and text2 values combined with periods and displayed in a msgbox and put in text3

Regards
Mark
 
Thanks so much Mark.
Best Regards
Bill
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top