Link to home
Create AccountLog in
Avatar of route217
route217Flag for United Kingdom of Great Britain and Northern Ireland

asked on

proper function vba or data validation

Hi Experts excel 2010

How would you used either vba or data validation...so when a user enters text data into cells b6:b100...the proper function is applied...correcting the first letter of the text to upper case...I. e. Auto correct...the input
SOLUTION
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of route217

ASKER

Thanks for the feedback...

I just typed into cell b6 cyber issues and did not correct the text...
Avatar of Excel amusant
Excel amusant

Hi,

Example attached.

Best,
--crp.unops.local-files-UserHome-Sh.xlsb
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account