Display The Find Dialog in a Macro in Excel Video

How to Display The Find Dialog in a Macro in Excel

This "How to Display The Find Dialog in a Macro in Excel" video requires the latest version of Adobe Flash Player.
Download Flash

Get Flash

Display The Find Dialog in a Macro in Excel -

Laura asks how to display the Find dialog in a macro. The macro recorder won't do it....

Display The Find Dialog in a Macro in Excel -

Laura asks how to display the Find dialog in a macro. The macro recorder won't do it. Application.Dialogs().Show won't do it. Episode 954 shows you a kludge to solve this problem. This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Learn one of the 377 tips from the book.

Added:

12/12/08

Tags:

Display The Find Dialog in a Macro in Excel Display The Find Dialog Excel Lessons Excel tips excel tutorial The Find Dialog excel, mrexcel, SendKeys spreadsheets,

URL:

Embed: (More)

Comment on this Video

Your Name: Email (optional):

Are you human?

Comments
Add-ons
Links
Related
Transcript

By: Guest 4 months ago

Application.Dialogs( xlDialogFormulaFind) .Show ...?

Reply to this Comment

No text or picture Add-ons were added yet. How sad!

No Links were listed yet. Go ahead and share!

Learn how to Create Sparklines in Excel 2010

- Sparklines are tiny, word-sized charts that can appear in a cell. Excel 2010 makes it easy to create sparklines. In Episode 1070, Mike & Bill show you several examples in Excel 2010. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

MrExcel's Learn Excel #936 - Paste the Total

Excel Lessons: Paste the Total - Pablo sends in a great question: why can't you copy a range of cells and paste only the total of those cells in a new cell? Microsoft should really add this functionality, but in the meantime, 2 lines of macro code solve the problem. Episode 936 shows you how. This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

How to Use Excel 2010s New Features

- A preview of new features coming in Excel 2010: Episode 1066 shows you the Paste Options shortcuts in Excel 2010.

MrExcel's Learn Excel #941 - Count Combinations

Excel Lessons: Count Combinations - Sergio from Mexico asks how to count unique combinations of two fields. Episode 941 shows three methods for solving this problem. This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

MrExcel's Learn Excel #923 - Icon Set Alignment

The one problem with icon sets is that they are always left-justified in the cell. Episode 923 will show you why this is a problem and how to overcome it. This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

MrExcel's Learn Excel #954 - Macro Display Dialog

Excel Lesson - Macro Display Dialog - Laura asks how to display the Find dialog in a macro. The macro recorder won't do it. Application.Dialogs().Show won't do it. Episode 954 shows you a kludge to solve this problem.

MrExcel's Learn Excel - Redux

Excel Lesson - Redux - Episode 954 brought an avalanche of mail on three fronts. (1) SendKeys is really cool, how do you do Alt instead of Ctrl? (2) Why the macro when you could select Entire Workbook in the dialog? (3) Application.Dialogs would have worked, the dialog is misnamed.

Learn Excel from MrExcel Episode 917 - Chart Background

Add a picture as a background for a chart in Excel 2007. Episode 917 shows you how. This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

How to Use Excel 01 - Chinese

Learn How To Use Excel in this easy to follow step by step tutorial.

Learn Excel from MrExcel Episode 918 - Chart Background 2003

How to Change Chart Background in Excel 2003 - Changing the chart background in Excel 2003. Episode 918 shows you how.

There is no transcript for this video yet – check back soon.