| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to delete the "Insert Function Dialog Box" (dialog box only)? | Excel Worksheet Functions | |||
| Go To Dialog box | Excel Discussion (Misc queries) | |||
| dialog box | Excel Discussion (Misc queries) | |||
| What does TrailingMinusNumbers do in the TextToColumns Method | Charts and Charting in Excel | |||
| Dialog Box | Excel Discussion (Misc queries) | |||
![Howie[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
