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?