| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Capitalising an active cell
G'day Everyone
can someone help fill the blanks (using 2000 format) in the following please. I need for each cell containing data in column of "F" to AutoCapitalise after the user moves to any other cell. I know in Access you can force the field to do this, but I am unsure of the Excel equivalent. Now, I know this next bit is way wrong, so if anyone has something to fill the gaps in, that'd be sweet. Private Sub Worksheet_SelectionChange(ByVal Target As Range) activecell.Format = AutoCapital End Sub TIA Regards Mark. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| set the background color of the current cell(active cell) | New Users to Excel | |||
| referring to formula in a non active cell from active cell | Excel Discussion (Misc queries) | |||
| Active Cell in Auto Filter | Excel Discussion (Misc queries) | |||
| Capitalising text | Excel Discussion (Misc queries) | |||
| HOW TO COPY 480 ACTIVE E-MAIL ADDRESSES CLM "G" ON AN ACTIVE EXCE. | Excel Discussion (Misc queries) | |||
Threaded Mode
