I tried a bit to figure this out, and I cant seem to get it. The goal
is to have a function trigger off of a change in the drop down list
that exists in cell F1. The dropdown makes it hard. But I don't know
how else to do it because I already have a bunch of manual trigger
macros with buttons, this one would be nice to have trigger itself I
suppose.

Range(F1) changes need to call "Process"

Thanks,
-Pistolade-

Use the _Change event of the sheet containing the DV list. Just have
the code run "process" when Target = Range("F1"). (Though I'd use a
defined named for F1)

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
If Target = Range("F1") Then _
MsgBox "you selected '" & Target.Value & "'!"
End Sub

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion