- In the extension bar, click the AdBlock Plus icon
- Click the large blue toggle for this website
- Click refresh
- In the extension bar, click the AdBlock icon
- Under "Pause on this site" click "Always"
- In the extension bar, click on the Adguard icon
- Click on the large green toggle for this website
- In the extension bar, click on the Ad Remover icon
- Click "Disable on This Website"
- In the extension bar, click on the orange lion icon
- Click the toggle on the top right, shifting from "Up" to "Down"
- In the extension bar, click on the Ghostery icon
- Click the "Anti-Tracking" shield so it says "Off"
- Click the "Ad-Blocking" stop sign so it says "Off"
- Refresh the page
- In the extension bar, click on the uBlock Origin icon
- Click on the big, blue power button
- Refresh the page
- In the extension bar, click on the uBlock icon
- Click on the big, blue power button
- Refresh the page
- In the extension bar, click on the UltraBlock icon
- Check the "Disable UltraBlock" checkbox
- Please disable your Ad Blocker
- Disable any DNS blocking tools such as AdGuardDNS or NextDNS
- Disable any privacy or tracking protection extensions such as Firefox Enhanced Tracking Protection or DuckDuckGo Privacy.
If the prompt is still appearing, please disable any tools or services you are using that block internet ads (e.g. DNS Servers, tracking protection or privacy extensions).
Question
rageagainstmachine
OK guys, I want to have a few textboxes that only accept numerical chars, not letters. Therefore I need some sort of validation as soon as the user has entered something into the textboxes to prevent this. I have demonstrated this below in a basic way, whereby if the user enters a letter ?a? then they will get an error message, however it will still leave the letter a in the textbox which is no good. Plus I need it for all the alphabet, not just ?a?. There must be an easier way todo what I require, can anyone help?
Private Sub TextBox2_Change()
If TextBox2 = ?a? Then MsgBox "Enter Numerical characters only "
Link to comment
https://www.neowin.net/forum/topic/621013-vba-excel-textbox-to-accept-numbers-only/Share on other sites
5 answers to this question
Recommended Posts