| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Upper on certain cells.
See
http://www.mvps.org/dmcritchie/excel/proper.htm and http://www.cpearson.com/excel/case.htm You can try Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Not Application.Intersect(Range("a1,a6,b1,b6"), Target) Is Nothing Then Target.Formula = StrConv(Target.Formula, vbUpperCase) End If End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "Ctech" wrote in message ... Can I have a on event on a set cells? As I want the macro to run just when the text in 4 cells is changed... A1, G5, H3, C17 -- Ctech ------------------------------------------------------------------------ Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745 View this thread: http://www.excelforum.com/showthread...hreadid=528142 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto change all caps to upper and lower case | Excel Discussion (Misc queries) | |||
| Auto change all caps to upper and lower case | Excel Discussion (Misc queries) | |||
| Changing upper case characters to upper/lower | Excel Discussion (Misc queries) | |||
| Auto Upper Case | Excel Discussion (Misc queries) | |||
| How do I convert all upper case excel sheet into upper and lower . | Excel Discussion (Misc queries) | |||
Threaded Mode
