ExcelBanter - TextToColumns Dialog

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - TextToColumns Dialog (https://www.excelbanter.com/excel-programming/280834-texttocolumns-dialog.html)

Howie[_3_]

TextToColumns Dialog

Anyone know how to invoke the textToColumns dialog box,
and whether you can capture the info that the user
supplies to the dialog?

Tom Ogilvy

TextToColumns Dialog

The only way to capture the information is to use the macro recorder.

application.Dialogs(xlDialogTextToColumns).Show

--
Regards,
Tom Ogilvy

"Howie" wrote in message
...
Anyone know how to invoke the textToColumns dialog box,
and whether you can capture the info that the user
supplies to the dialog?

All times are GMT +1. The time now is 02:21 AM.