Macro : Allow only Upper Case Entries in Excel Sheet

0 views
Skip to first unread message

Ashu K

unread,
Jan 28, 2016, 6:28:04 AM1/28/16
to Excel VBA Lab
Dear Seniors,

If i write anything in excel sheet in lower case, data will be automatically converted in upper case. I need, excel sheet is allowed only upper case entries.

please help in this.




Thanks
Ashu Kenith

Ashish Kumar

unread,
Jan 28, 2016, 10:40:35 PM1/28/16
to Excel...@googlegroups.com
Hi Ashu,


Check this...!



Note : Please visit on forum page for download the sheet.


Regards
Ashish Kumar
Allow Only Upper Case Entries.xlsm

Ashu K

unread,
Jan 29, 2016, 7:41:30 AM1/29/16
to Excel VBA Lab
Dear Ashish Sir,


It's working perfect for me.

Thanks for solve my problem




Thanks & Regards
Ashu Kenith

Vaibhav Joshi

unread,
Jan 29, 2016, 7:47:12 AM1/29/16
to Ashu K, Excel VBA Lab
Great work ashish..

--
www.ExcelVbaLab.com
---
You received this message because you are subscribed to the Google Groups "Excel VBA Lab" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ExcelVbaLab...@googlegroups.com.
To post to this group, send email to Excel...@googlegroups.com.
Visit this group at https://groups.google.com/group/ExcelVbaLab.
 To view this discussion on the web visit https://groups.google.com/d/msgid/ExcelVbaLab/51747a0a-874a-4428-a5ca-eb21aea3b3ab%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

Ashish Kumar

unread,
Jan 29, 2016, 9:26:17 AM1/29/16
to Excel VBA Lab
Dear Vaibhav Sir,

Thanks for Acknowledge



Regards
Ashish Kumar

On Friday, January 29, 2016 at 6:17:12 PM UTC+5:30, vabs wrote:
Great work ashish..

Ashish Kumar

unread,
Jan 29, 2016, 9:27:01 AM1/29/16
to Excel VBA Lab
Welcome Ashu.



Regards
Ashish Kumar

Ashish Bhalara

unread,
Jan 29, 2016, 10:33:41 PM1/29/16
to Excel VBA Lab
Hi Ashish Kumar,

Its perfect solution, excellent use of looping, really appreciable work.

Regards
Ashish Bhalara

--
www.ExcelVbaLab.com
---
You received this message because you are subscribed to the Google Groups "Excel VBA Lab" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ExcelVbaLab...@googlegroups.com.
To post to this group, send email to Excel...@googlegroups.com.
Visit this group at https://groups.google.com/group/ExcelVbaLab.

Ashish Kumar

unread,
Jan 29, 2016, 11:02:45 PM1/29/16
to Excel VBA Lab, excel...@googlegroups.com
Dear Ashish Bhalara,

Thanks for acknowledge.



Regards
Ashish Kumar

Vibhuti Shrotriya

unread,
Feb 2, 2016, 9:31:27 AM2/2/16
to Excel VBA Lab
Dear Ashish,

It's working as per the query. It easy to use and very useful.



Regards
Vibhuti.

Ashish Kumar

unread,
Feb 2, 2016, 10:25:13 AM2/2/16
to Excel VBA Lab
Thanks for Acknowledge.


Regards
Ashish Kumar
Reply all
Reply to author
Forward
0 new messages