I want a user to select option button which will control the text length in a text box.
Some users may fill e.g. text upto 200 characters, some to 400 characters etc. to describe an event in the same text box in a userform I have designed.
I do not have any code but can anybody suggest...
Hello folks. I want to be able to see how many characters I am typing into a cell as I type. I know there are many ways to see the length after the data is entered, but I need to see the count 'in-flight' if possible.
Hello,
Small problem.
I have wide table for punching data. For many columns there is the same two word as headers. (the dates might change so can't use formula in the tableheaders).
Creating the table will then leave me with:
Budget | Actual | Budget1 | Actual1 | Budget2 | and so on.
So I...
Hi all,
I am trying to put data validation on some cells that will not allow any entry if H6 has a text length of less than 4. Can anybody help with this formula?
Thanks
Andrew
Hello. I am trying to limit the number of characters in an Excel 2010 worksheet created with data imported from another program. Specifically, I need each column to have no more than 30 characters. I have tried the Data Validation technique, but this does not seem to work with imported data...
I am trying to force my users into giving me data in a certain format. this particular cell needs to be atleast 10 numbers long, or if its greater than 10, the eleventh must be "/" followed by a last single numeric. for example: 1234567891 or 1234567899/1
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.