Find word and add text

dwarek

Board Regular
Joined
Jul 15, 2016
Messages
79
Hello everyone i have small doubt i have created a userform with few combo box,now the issue is when i select values from few combo box those values should get added after a word ,for example lets in cell a1 there is statement "THIS IS PEN" which is predefined and when i select a value in combo box for example "A" then in the result it should be like "THIS IS A PEN" is there a vba code for this issue . please help me out
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
This could be done. But how would the script know where to add the value.
Would it always be after the first space

For example would it be:

George A is my name

Many A apartments exist.
 
Upvote 0
the word exist only once in the sentence for example i have only one word named as OBJECT and after that combo box1 value should be added then i have word AMEND and after that combo box 2 value should be added ...and the whole sentence exist in one cell
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,237
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top