excel force caps

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Column < 5 Then Exit Sub
If Target.Column > 5 Then Exit Sub
On Error GoTo ErrHandler
Application.EnableEvents = False
Target.Formula = UCase(Target.Formula)
ErrHandler:
Application.EnableEvents = True
End Sub

adapted from this forum

http://www.excelforum.com/excel-formulas-and-functions/347695-automatically-change-text-to-uppercase.html

Comments

Post a Comment

Popular posts from this blog

pdf to png/jpg/etc

Not often I learn something at work that I need to put on here. Anyway, imagemagick: convert -density 600 input_file.pdf output_file.png Gives me a lovely hi-def version of the image. Too hi, probs, but at least it's relatively easy to resize (down) once it's in the appropriate image format.
Read more

diskfilter writes are not supported

http://askubuntu.com/questions/468466/why-this-occurs-error-diskfilter-writes-are-not-supported " It's a BUG! This is a bug that occurs in the most recent version of Ubuntu Server (Ubuntu Server 14.04 LTS), when you create the boot partition (or the root partition, when the boot partition doesn't exists) inside a LVM or a RAID partition. You can get more info about this bug in Ubuntu Launchpad: Bug #1274320 "Error: diskfilter writes are not supported" . Why does this bug occur? When the system is booting, GRUB reads ( load_env ) data in /boot/grub/grubenv . This file is called GRUB Environment Block . From the GRUB Manual: It is often useful to be able to remember a small amount of information from one boot to the next. [...] At boot time, the load_env command (see load_env) loads environment variables from it, and the save_env (see save_env) command saves environment variables to it. ...
Read more

no sound in Papers Please

No sound at all, actually. First I installed alsa-utils, checked alsamixer master was not muted. Installed pulseaudio and pavucontrol. This gave me sound on youtube but not the game. Eventually found this tip in the hotline miami AUR comments: On x86_64 I had to install lib32-libpulse to get sound working. Without the package there was that error: ALSA lib dlmisc.c:252:(snd1_dlobj_cache_get) Cannot open shared library /usr/lib32/alsa-lib/libasound_module_pcm_pulse.so AL lib: (EE) alsa_open_playback: Could not open playback device 'default': No such device or address   https://wiki.archlinux.org/index.php/Advanced_Linux_Sound_Architecture#Unmuting_the_channels https://aur.archlinux.org/packages/hotlinemiami/
Read more