thanks for the reply bsob,
i tried with the codings which you gave, but it does not reflect the textbox2.
Also i want to know why you use text1.text coz i use an inputbox and that should directly reflect textbox2 where you have the numbers like 2,4,8,12,35,99, 105 in textbox2. Through an inputbox i select the number that is unwanted as the same code which you have used
private sub ChangeUnwantedB tn_click() 'a button to change...

Thanks for your reply BSOB,
the input will be either 1 digit or 2 or 3 or more digit, which will in turn reflect in the second textbox, If i want to delete a particular number along with the comma by getting an input through a inputbox how should i write the program. Solution please.

I have two textboxes, where i give input in one textbox and it reflects in another textbox. for eg., entering page numbers in the first textbox will be displayed as 1,2,3,4.... in the second textbox.Now if i want to delete a particular number how can i delete. Solution please