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

GLeslie

New Member
Joined
Dec 30, 2013
Messages
3
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
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

GLeslie

New Member
Joined
Dec 30, 2013
Messages
3
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.
 
Upvote 0

nigelk

Well-known Member
Joined
Aug 30, 2008
Messages
535
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.

Code:
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
 
Upvote 0

GLeslie

New Member
Joined
Dec 30, 2013
Messages
3
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.

Code:
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
clip_image002.png

<tbody>
</tbody>
NameSteve
EntityBLANK
AddressBLANK
OfficeBLANK
MobileBLANKDate12/30/2013
Camera1 Tractor1
Hydrus T66
Camera2 Tractor2
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>
 
Upvote 0

Forum statistics

Threads
1,195,680
Messages
6,011,126
Members
441,586
Latest member
rodsin76

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top