Back in Episode 695, I used the InputBox function in VBA to ask for a couple of answers. In today's podcast, I will show you how to convert that macro to use a custom user form in Excel. Episode 701 shows you how.
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!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
MrExcel Excel Videos
Learn Excel from MrExcel - Excel tips and tricks from Bill Jelen.
Filters
Show only:
Loading…
Take your Excel data and plot it on a map using Microsoft MapPoint. Watch Episode 700 to learn how you can win a copy of MapPoint.
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!
A question from Gary: Why does Excel 2007 open with only 65,536 rows? Wouldn't Microsoft want to show off the cool functionality available in Excel 2007 without forcing you to up convert each worksheet? Episode 953 discusses the unfortunate setting causing 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!
Wale asks how to randomly choose 20 invoices from a population of 500 invoices. Episode 719 will show you two methods for solving this problem.
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!
Laura, Erik, and Howard all sent in similar workarounds to podcast 713. Today in Episode 718, we will take a look at how to offer a validation dropdown that will allow keyboard afficianados to enter values quickly.
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!
Matthew from Washington wants to take an event database and create a visual calendar that shows availability.
While this sounds simple, it requires several steps. The end result is fairly cool. Episode 717 shows you how.
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!
Today, in Episode 716 we take a look at the entries for the MapPoint contest, and also a chance to enter the MrExcel NCAA basketball game.
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!
In yesterday's podcast, we were frustrated that the Validation dropdown would not allow us to type a few letters of the entry. In Episode 714, we will take a look at a tiny userform and macro to replace the validation dropdown.
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!
