Select case using a range

**sigfreid** · 07-31-2009, 05:25 AM

Hi,

I'm creating a small spreadsheet for client data in Excel and I want it formatted a certain way, I did consider data validation but it proved to just be annoying.

I've been working on some VBA code to automatically change whatever text is typed into a cell to the correct case (ucase, lcase or proper) and while I can get it working for a single range of cells getting it to work for more is proving difficult.

This is what I have so far;

Please Login or Register  to view this content.

**royUK** · 07-31-2009, 06:12 AM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

I have added them this time

**sigfreid** · 07-31-2009, 06:58 AM

I think I've fixed it

Please Login or Register  to view this content.

Appears to work, could probably do with bit of tidying up tho. I wonder is it possible to combine all the ranges that I want in upper case into a single case and then all the ranges I want in proper case into a single one etc? One case for each range will look pretty awful.

**StephenR** · 07-31-2009, 07:10 AM

Why not like this?

Please Login or Register  to view this content.

**sigfreid** · 07-31-2009, 07:57 AM

Originally Posted by StephenR

Why not like this?

Well primarily becuase column B is to be in Proper Case and C an D are in Upper Case, but also because I don't want it to affect the column titles.

I did try

Please Login or Register  to view this content.

But it wouldn't work, hence the cases. I'm Currently trying to tidy up the code a bit for instance, where I need C2:C65535 , D2:D65535 and say G2:G65535 in upper case is it possible to have all 3 ranges in the same case?

**StephenR** · 07-31-2009, 08:19 AM

Please Login or Register  to view this content.

**sigfreid** · 07-31-2009, 09:17 AM

Cheers, that didn't quite do it, but got me pretty close and I've figured it out now.

Select case using a range

LinkBack

Thread Tools

Rate This Thread

Display

Select case using a range

Re: Select case using a range

Re: Select case using a range

Re: Select case using a range

Re: Select case using a range

Re: Select case using a range

Re: Select case using a range

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions