TextToColumns Dialog

  • Thread starter Thread starter Howie
  • Start date Start date
H

Howie

Anyone know how to invoke the textToColumns dialog box,
and whether you can capture the info that the user
supplies to the dialog?
 
The only way to capture the information is to use the macro recorder.

application.Dialogs(xlDialogTextToColumns).Show
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

TextToColumns prompt 4
For/Next Text to Columns 4
Automatically Accept Replace Values in Text-to-Columns macro 2
TextToColumns Destination:=another worksheet 1
TextToColumns Method: How to use xlFixedWidth? 1
sub TextToColumns 1
import text 1
Using "Equiv" excel fonction in vba 1

Back
Top