Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find End of String
Hi, I have a form that has two text box's. Next to each of these tex box's I have a checkbox. I want to allow the user to put a check nex to the text box's values he wants to include in a thrid textbox o another form. If there are more than one checkbox checked then I want comma between each value. Here is generically what I'm trying to do. Private Sub CommandButtonENGDescriptionNext_Click() If Me.CheckBoxENGID.Value = True Then Me.TextBoxDescriptionPageDescription.Value = Me.TextBoxEngineID.Value End If This is where I get stuck. What I want to happen is this: Then If Me.CheckBoxENGAccessoriesIncluded.Value = True Then Append Me.TextBoxDescriptionPageDescription.Value = ", " Me.ComboBoxAccessoriesYesNo.Value to the end of the string. End If End Sub How do I do this? Thanks Jod -- ssjod ----------------------------------------------------------------------- ssjody's Profile: http://www.excelforum.com/member.php...fo&userid=3339 View this thread: http://www.excelforum.com/showthread.php?threadid=56604 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find String in another string - only between spaces | Excel Worksheet Functions | |||
Find Many String options in ONE String | Excel Worksheet Functions | |||
search a string withing a string : find / search hangs | Excel Programming | |||
backwards find function to find character in a string of text | Excel Programming | |||
find a string inside another string | Excel Programming |