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!
I added tabs inside my userform. Is there a way to display cells in a spreadsheet here?
LincolnHo 10 months ago
You make it look very easy to write VBA.
notnowwhy 10 months ago
Great Video. Anymore VBA Userform video? I would like to message this in Mr Excel message board as well. Excellent :)
MCID4500 2 years ago