Down and dirty where do I put it?

[KA3PMW]

I have 2 spread sheets that I need to have all entries on in uppercase. I did have one working but it quit.

If I supply the sheets can someone please tell me where to put the VBA code?

Thank you in advance.

 

[jproffer]

No need to supply the sheets, but are you talking about changing everything after the fact, or as new entries are typed into the cells?

If you want an ongoing automatic change as cells are modified, try this in the worksheet code:

Private Sub Worksheet_Change(ByVal Target As Range)
Target.Value = UCase(Target.Value)
End Sub

Right click on the worksheet tab, select "View Code", paste that into the white area on the right.

 

[mumps]

Copy and paste this macro into the worksheet code module for each sheet. Do the following: right click the tab for your first sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Repeat the process for your second sheet. Close the code window to return to your sheet.

Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
    Application.EnableEvents = False
    Target(1).Value = UCase(Target(1).Value)
    Application.EnableEvents = True
End Sub

 

[Yongle]

To avoid duplicating the code for multiple sheets (using code provided by mumps )
- amend Name1 and Name2 to match the 2 sheet names

and place this in ThisWorkbook module

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
    If Sh.Name = "[COLOR=#ff0000]Name1[/COLOR]" Or Sh.Name = "[COLOR=#ff0000]Name2[/COLOR]" Then
        Application.EnableEvents = False
        Target(1).Value = UCase(Target(1).Value)
        Application.EnableEvents = True
    End If
End Sub

 

[KA3PMW]

Thanks, that seems to have done the trick. Now to get one of my links back

 

[KA3PMW]

Thanks, I think that fixed it.

 

[KA3PMW]

Can't find the SOLVED again. It is not under Thread tools.

 

[KA3PMW]

Got another problem. The Add/Edit Spotters keeps losing the link when I open Emergency Log.xls
I keep resetting the link and saving the Log but it seems to lose it again. What am I missing???