Building a workbook need help with how to make things happen (rookie here)

[GLeslie]

Hello All,
I am trying to make a work book that my make my sales job a little easier when I am out in the field.

Page 1 I want to have client information
Page 2 would be a summary page that carries client info over (got this done)
I have a series of 6 and may end up in 10 drop downs that have our products in them
I have a area for notes
Pages 3-37 are equipment specification relating to each drop down box.
Is there a way when a specific item is selected from a drop down box that it will allow me to automatically print the page 2 summary sheet and the specific product specifications selected to hand to the potential client while I am there with them or do I need to select the print pages individually.

I cant help but think there has got to be a way to automate this process

any help would be greatly appreciated

 

[GLeslie]

Hello All,
I am trying to make a work book that my make my sales job a little easier when I am out in the field.

Page 1 I want to have client information
Page 2 would be a summary page that carries client info over (got this done)
I have a series of 6 and may end up in 10 drop downs that have our products in them
I have a area for notes
Pages 3-37 are equipment specification relating to each drop down box.
Is there a way when a specific item is selected from a drop down box that it will allow me to automatically print the page 2 summary sheet and the specific product specifications selected to hand to the potential client while I am there with them or do I need to select the print pages individually.

I cant help but think there has got to be a way to automate this process

any help would be greatly appreciated

If needed I can email or find another way to share my workbook and let you see what I am trying to do since I am certain I did not explain this very clearly for some of you to understand what I am trying to do.

Thanks again in advance for your assistance.

 

[nigelk]

You can always use the worksheet change event to capture the change in the drop downbox.

For example, if I had a drop down box in cell F4, and the selections were Red, Green, Yellow, depending on what was selected, I could print out the sheet of my choice.

Private Sub Worksheet_Change(ByVal Target As Range)

Dim str As String

If Target.Address <> ("$F$4") Then
Exit Sub
End If

str = Target.Value

If str = "Green" Then
MsgBox "Print Sheet1"
End If

If str = "Red" Then
MsgBox "Print Sheet2"
End If


End Sub

 

[GLeslie]

You can always use the worksheet change event to capture the change in the drop downbox.

For example, if I had a drop down box in cell F4, and the selections were Red, Green, Yellow, depending on what was selected, I could print out the sheet of my choice.

Private Sub Worksheet_Change(ByVal Target As Range)

Dim str As String

If Target.Address <> ("$F$4") Then
Exit Sub
End If

str = Target.Value

If str = "Green" Then
MsgBox "Print Sheet1"
End If

If str = "Red" Then
MsgBox "Print Sheet2"
End If


End Sub

Ok- I tried this and it sort of worked once but then not again

The way the sheet is set up is that it has (will have 12 drop downs)
Each drop down will have between 5 and 100 selections
I need the form to allow me to select or not select items in the drop downs and print them after everything is selected.

The sheet I have put together looks something like this.

Any pointers/directions etc. would be greatly appreciated!!!

Post Demo Review

<tbody> </tbody>

Name

Steve

Entity

BLANK

Address

BLANK

Office

BLANK

Mobile

BLANK

Date

12/30/2013

Camera

1

Tractor

1

Hydrus

T66

Camera

2

Tractor

2

Reel

Build Choice

KW305

14' Box (Gas)

Accessory

Accessory

Pressure Test Set

Accessory

Accessory

Accessory

Accessory

NOTES:

This information is supplied on the spot and may require additional adjustements to ensure that you are getting all the items needed to fulfill your needs.

Information Supplied By:

<colgroup><col span="3"><col><col><col><col><col><col span="2"><col span="3"><col></colgroup><tbody>
</tbody>