Vba code to output the text box containing selected data with comma.

Hi Forum,

I need VBA code to output the text box contains the selected cells data with comma
pls see attached file for more explanation.

If selected cells are

M135380
M136455
M136456
A821785
M142353
A974065
M017029
A135381
A135351
M135443


I want below output in new text box.

M135380,M136455,M136456,A821785,M142353,A974065,M017029,A135381,A135351,M135443

Hi, satputenandkumar0,

maybe like this

Please Login or Register  to view this content.

Ciao,
Holger

Please Login or Register  to view this content.

but you did not put a textbox in your attached file, but a shape.

Thanks Holger,

It works perfect.

Thanks patel45 for givng solution.

Hi, satputenandkumar0,

if you want to use the code in any other workbook make sure to know the running number of the shape.

@patel45,
nice bit of macro-recorder code with a loop and not dimmed variables. The last comma from the string should be omitted.

Ciao,
Holger

ok sir,

Thanks for advice.

Sir,

Is it possible that output will come with new notepad file every time I run code.

Hi, satputenandkumar0,

yes - it is. But isnīt that a different topic than sending the text to a shape?

Please Login or Register  to view this content.

You might need to change the path and folder as well as check the location of Notepad.exe

Ciao,
Holger

sir,

getting below error

Run-time error '76':
Path not found

Hi, satputenandkumar0,

Originally Posted by Post#10

You might need to change the path and folder as well as check the location of Notepad.exe

If you donīt have the directory Temp on your local HDD in Drive C: the error is understandable - or did you miss the backslash at the end of the path?

Ciao,
Holger

ok sir, it's done

I remove "\" in below code.

Please Login or Register  to view this content.

Now it's work nice

Thanks a lot