Masta
New Member
- Joined
- Feb 22, 2022
- Messages
- 33
- Office Version
- 2021
- 2019
- 2016
- Platform
- Windows
This solution only works for one first word. Sample " Blue, Silver, line of production mixed with Red, Gold 258" ..... In this sentence, I need to single out the following words and numbers. In two different TextBoxes. I really need help with this program line. I don't have much experience with excel vba. "Blue, Silver and Red, Gold 258".
Private Sub CommandButton207_Click()
Dim ws As Worksheet
Set ws = Worksheets("Models")
ws.Range("K71") = Left(ws.Range("K70"), (Application.WorksheetFunction.Find((","), ws.Range("K70"), 1) - 1))
End Sub
Private Sub CommandButton207_Click()
Dim ws As Worksheet
Set ws = Worksheets("Models")
ws.Range("K71") = Left(ws.Range("K70"), (Application.WorksheetFunction.Find((","), ws.Range("K70"), 1) - 1))
End Sub