Re: Force Caps Lock

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: John (r._at_9999yahoo.co.uk)
Date: 05/25/04 

Date: Tue, 25 May 2004 21:45:17 +0100

You make a valid point Chip on my posts so I'll expand

on all bar kkknie's code nothing at all happens

On kkknie's post t it hits debug which highlights the whole line. Only a
very novice user on VBA so I am unsure of what further detail this debug
will give me

What I am trying to achieve is that say, when a user clicks the print Icons
all values within a range are forced upper case.

Hope that makes it clear

"Chip Pearson" <chip@cpearson.com> wrote in message
news:OuL3jgpQEHA.2704@TK2MSFTNGP10.phx.gbl...
> John,
>
> Rather than posting 4 replies simply stating "it doesn't work",
> you should describe why the proposed solution doesn't work. Does
> nothing happen? Do you get an error? What error?
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
>
>
> "John" <r.@9999yahoo.co.uk> wrote in message
> news:7SNsc.469$Z14.451@news.indigo.ie...
> > Sorry for being a pain KK but I'm still getting a debug
> >
> >
> > "kkknie >" <<kkknie.16tls7@excelforum-nospam.com> wrote in
> message
> > news:kkknie.16tls7@excelforum-nospam.com...
> > > I was afraid that wouldn't work. Should have tested (duh).
> > >
> > > Modify to this:
> > >
> > > Dim r as Range
> > >
> > > For Each r in Sheets("Template").Range("A9:C43").Value
> > > r.Value = UCase(r.Value)
> > > Next
> > >
> > > This will loop through the cells individually and should
> work.
> > >
> > > K
> > >
> > >
> > > ---
> > > Message posted from http://www.ExcelForum.com/
> > >
> >
> >
>
>

Relevant Pages

  • Re: Did we ever get a solution to CE6 Slow Debug Message Flusing??
    ... hardware) or for those without spare serial ports. ... I must agree with previous posts in this thread too. ... "Dean Ramsier" wrote: ... Isn't it possible to reroute the KITL messages to a standalone debug ...
    (microsoft.public.windowsce.platbuilder)
  • Re: My predictions for 2004-2005
    ... I'm sure you'll get posts on predictions folks ... The Itanium does run the 32-bit software, ... (as compared to a 32-bit chip). ...
    (borland.public.delphi.non-technical)
  • Re: Security Alert in Access 2007
    ... I have no opinions on whatever ideas you ... If you wish to trawl through my past posts to see if you can get one over ... There's that chip again Chris. ... I just call a spade a spade as I see it, and I don't care how "expert" the ...
    (microsoft.public.access.security)
  • debug multiple projects
    ... I've tried to find other posts on this and haven't found anything that was ... I've gone into the c# project and enabled asp.net debugging. ... I've got my web.config project set to debug. ... source and symbol files. ...
    (microsoft.public.vsnet.debugging)
  • Re: Buy or Sell PokerStars Play Money - Now We Have Sister Sites Too!!
    ... TO STOP INTERNET SCAMMERS THROUGH POKER SITES. ... strike force to bring down this hideous Play Chip scammer. ... themselves where as the chip store owners posts will be in another) ...
    (rec.gambling.poker)