By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,984 Members | 1,025 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,984 IT Pros & Developers. It's quick & easy.

Set all font to capital letters

P: 8
I am trying to set certain cells to capitalize any input whethere they have the caps lock on or not. I have toyed with "Private Sub Workbook_SheetChange" to turn all changes into an object with capital letters, but I am afraid if anyone ever removed the protection, that could be dangerous. I have also set the font on some of my worksheets to Perpetua Titling MT, which works well except that the font is a little funky. For some reason, on my summary page, setting that font on cells has no effect and the font still shows as Arial. Does anyone have any suggestions of how to safely make these cells show caps only safely?
Sep 4 '07 #1
Share this Question
Share on Google+
3 Replies


Ali Rizwan
100+
P: 927
I am trying to set certain cells to capitalize any input whethere they have the caps lock on or not. I have toyed with "Private Sub Workbook_SheetChange" to turn all changes into an object with capital letters, but I am afraid if anyone ever removed the protection, that could be dangerous. I have also set the font on some of my worksheets to Perpetua Titling MT, which works well except that the font is a little funky. For some reason, on my summary page, setting that font on cells has no effect and the font still shows as Arial. Does anyone have any suggestions of how to safely make these cells show caps only safely?
Tell me whether you are trying to display the fields in textboxes or in labels or in DataGrid.
If datagrid then i ll search for you more instead otherwise use Ucase( ) command.
reply
Sep 4 '07 #2

P: 8
Yes, in the datagrid
Sep 4 '07 #3

Ali Rizwan
100+
P: 927
Yes, in the datagrid
Ok
I have an idea. Tell me that r u updating record directly from dgrid or using textboxes.
textboxes is the good & secure way to update record.
use UCase() for textboxes for uppercase then dgrid is always updated with ucase.
I ll made up an example for u jusst wait for some minutes.
Sep 4 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.