Joe Marten sends in a better way to limit the number of characters entered in a cell. Episode 599 shows you how.
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
Transcript of the video:
Hey, welcome back to the MrExcel netcast. I'm Bill Jelen.
Today I want to talk about episode 585. This is where we were trying to limit the number of characters that can be entered in a cell.
Joe Martin who's a frequent contributor to the podcast sent in a great idea.
He said you can do this without VBA at all.
Just go to "View" "Toolbars" and turn on the "Control toolbox".
We want to go into the design mode that's the top left cell here, and then we're going to draw a text box.
We'll take the text box and we're going to make it conform to the cell by holding down the Alt key that'll make sure the text box fits a certain number of cells and then we're going to hit the properties button.
That's the little hand pointing to the white sheet and say that the max length is maybe 15.
All right.
We'll close the properties and exit design mode and we end up with a text box that we click inside this text box, and we can type anything up to 15 characters but if we try and go beyond that it stops us.
So this is pretty cool. It doesn't require any VBA at all.
you're actually using a little VBA control, but just basically setting the properties and much easier solution than what we had in podcast 585.
So thanks to Joe for sending that in thanks to you for stopping by.
We'll see you next time for another netcast from MrExcel.
Today I want to talk about episode 585. This is where we were trying to limit the number of characters that can be entered in a cell.
Joe Martin who's a frequent contributor to the podcast sent in a great idea.
He said you can do this without VBA at all.
Just go to "View" "Toolbars" and turn on the "Control toolbox".
We want to go into the design mode that's the top left cell here, and then we're going to draw a text box.
We'll take the text box and we're going to make it conform to the cell by holding down the Alt key that'll make sure the text box fits a certain number of cells and then we're going to hit the properties button.
That's the little hand pointing to the white sheet and say that the max length is maybe 15.
All right.
We'll close the properties and exit design mode and we end up with a text box that we click inside this text box, and we can type anything up to 15 characters but if we try and go beyond that it stops us.
So this is pretty cool. It doesn't require any VBA at all.
you're actually using a little VBA control, but just basically setting the properties and much easier solution than what we had in podcast 585.
So thanks to Joe for sending that in thanks to you for stopping by.
We'll see you next time for another netcast from MrExcel.
