Macros

[JamesPW]

Why does this macro not appear in my macro list? I'm aware that if it has "parameters" it won't appear but I don't what parameters are. If this is the reason, what parts of my code are parameters? Thanks

Private Sub Button298_click()

Dim i As Integer

For i = 3 To 14

If Range(Cells(27, i), Cells(27, i)).Font.Color <> vbBlack Then
Cells(28, i).Value = 0
Else
Cells(28, i).Value = 1
End If
Cells(28, i).Font.Color = Cells(27, i).Font.Color
Next i
MsgBox "Update Complete"

End
End Sub

 

[mumps]

The macro won't appear in the macro list if it is placed in the code module for the worksheet or in a code module in a userform.

 

[Fluff]

That code won't appear in the macro list because it starts with the word "Private"
The Parameters (when they exist) appear in the () after the sub name.

 

[JamesPW]

The macro won't appear in the macro list if it is placed in the code module for the worksheet or in a code module in a userform.

Thanks for the quick response. As you can see I know enough about macros to get me into trouble.
I'm not sure what "code module" or "Userform" is.
The macro is in Module1. Is this a "code Module"?.
VBA Projects (filename)
Sheet1 (tabname)
Sheet2 (tabname)
Modules
Module1

Button298 is on Sheet 2. If I move the macro to Button298 will it appear?

Thanks again

 

[mumps]

Explaining the various types of modules and how and when to use them would take considerable time. I think that it may be appropriate for you to do a some research on the topic. This link could perhaps provide you with a start: http://www.cpearson.com/excel/codemods.htm

 

[gallen]

Thanks for the quick response. As you can see I know enough about macros to get me into trouble.
I'm not sure what "code module" or "Userform" is.
The macro is in Module1. Is this a "code Module"?.
VBA Projects (filename)
Sheet1 (tabname)
Sheet2 (tabname)
Modules
Module1

Button298 is on Sheet 2. If I move the macro to Button298 will it appear?

Thanks again

Check out post number 3. As Fluff says the reason it isn't visible is it is marked 'Private' if you marked it as public then it would be visible. Your sub doesn't contain any parameters

So this should be visible when stored in a module:

[B][COLOR=#ff0000]Public[/COLOR][/B][COLOR=#333333] Sub Button298_click()
[/COLOR]

[COLOR=#333333]Dim i As Integer[/COLOR]

[COLOR=#333333]For i = 3 To 14[/COLOR]

[COLOR=#333333]If Range(Cells(27, i), Cells(27, i)).Font.Color <> vbBlack Then[/COLOR]
[COLOR=#333333]Cells(28, i).Value = 0 [/COLOR]
[COLOR=#333333]Else[/COLOR]
[COLOR=#333333]Cells(28, i).Value = 1[/COLOR]
[COLOR=#333333]End If [/COLOR]
[COLOR=#333333]Cells(28, i).Font.Color = Cells(27, i).Font.Color[/COLOR]
[COLOR=#333333]Next i[/COLOR]
[COLOR=#333333]MsgBox "Update Complete"[/COLOR]

[COLOR=#333333]End[/COLOR]
[COLOR=#333333]End Sub[/COLOR]

 

[JamesPW]

Why does this macro not appear in my macro list? I'm aware that if it has "parameters" it won't appear but I don't what parameters are. If this is the reason, what parts of my code are parameters? Thanks

Private Sub Button298_click()

Dim i As Integer

For i = 3 To 14

If Range(Cells(27, i), Cells(27, i)).Font.Color <> vbBlack Then
Cells(28, i).Value = 0
Else
Cells(28, i).Value = 1
End If
Cells(28, i).Font.Color = Cells(27, i).Font.Color
Next i
MsgBox "Update Complete"

End
End Sub

Thanks to all