Sales Funnel

[alfiajamel]

I am trying to create a form for forcasting. I want to, try to anyway, have
a picture of a funnel that changes as the sale moves through the sales
process. Does anyone have any ideas?

 

[Klatuu]

Put several pictures of funnels showing variace levels of full on your form.
Put all of them exactly in the same place so they overlay each other. Make
all Their Visible properties = No.

Then when you want to show a certain level of fullness, make that control
visible and the others hidden.

 

[alfiajamel]

Thanks! If I make that Visible properties=no, what kind of coding would i
use to show the correct funnel picture

 

[Klatuu]

Let's say you have 6 funnels named funnel1, funnel2...funnel6.

Then when you want to show say funnel 4, I would thing a sub you can call
with the number you want to show would be like:

Private Sub ShowFunnel(FunnelNumber As Long)
Dim ctl As Control

For each ctl in Me.Controls
If Left(ctl.Name, 6) = "Funnel" Then
If Clng(Right(ctl.Name,1) = FunnelNumber Then
ctl.Visible = True
Else
ctl.Visible = False
End If
End If
Next ctl
End Sub

Note this is untested "air" code and may need some debugging.

 

[alfiajamel]

I will try that! Thank you so much!

Let's say you have 6 funnels named funnel1, funnel2...funnel6.

Then when you want to show say funnel 4, I would thing a sub you can call
with the number you want to show would be like:

Private Sub ShowFunnel(FunnelNumber As Long)
Dim ctl As Control

For each ctl in Me.Controls
If Left(ctl.Name, 6) = "Funnel" Then
If Clng(Right(ctl.Name,1) = FunnelNumber Then
ctl.Visible = True
Else
ctl.Visible = False
End If
End If
Next ctl
End Sub

Note this is untested "air" code and may need some debugging.