excel_2009
Active Member
- Joined
- Sep 14, 2009
- Messages
- 318
Hi excel gurus
I'm currently working on a user form which works great however a user has to input similar data in two boxes but in reality the first box contains all the data however the second box only requires the first word from the initial text box e.g
First text box contains :
Samsung Galaxy S2
The second text box only needs the following:
Samsung
Is there anyway of doing this efficiently as opposed to keeping two text boxes? I.e. storing the first word so that I can use it later in my code? Thus removing the need for the second box?
I hope this makes sense!
Thank you
I'm currently working on a user form which works great however a user has to input similar data in two boxes but in reality the first box contains all the data however the second box only requires the first word from the initial text box e.g
First text box contains :
Samsung Galaxy S2
The second text box only needs the following:
Samsung
Is there anyway of doing this efficiently as opposed to keeping two text boxes? I.e. storing the first word so that I can use it later in my code? Thus removing the need for the second box?
I hope this makes sense!
Thank you