textbox - stop users only entering a space as user name help

[janger]

Hi

Is there a way to stop users only entering a user name as spaces only. I have a textbox which the user needs to enter then name to progress onto the next stage when clicking a command button. I have set the textbox so they have to enter a user name, However, if the user just enters spaces it will let them progress. I don't want to remove all spaces and can't find any help on the forums with this specific issue. The workbook is using userforms only.

Currently using code

Please Login or Register  to view this content.

Thanks

[etaf]

as part of your solution, you may need to expand the validation.
Many years ago, i worked in MI for a global corporation and often found , . space and various other characters , allowing the input to be moved to the next field.
So i suspect if you fix the space, the next will be a dot to overcome the entry issue
Just a thought, i dont answer VBA questions , so will leave

[janger]

Hi

A valid point and something I need to think about, hopefully there is a way round this.

Thanks

[romperstomper]

To start with, you could use:

Please Login or Register  to view this content.

[janger]

Will give it a try Thank you