LOOKING F/IDEAS

[Fernando Duran]

I'm planing to expand a program, that it works in a simple way, one of
the entries is the transport, every transport use it their own
tables, zones and prices.. I have to design one form for all the
differents transports... my problem is..
Transport A --------- Table for zones
Table for price calculation

Transport B---------- Table for zones
table for price calculation

etc....
How can i do, to go to the proper tables, according to transport
choice?

Thanks in advance

 

[Norman Harker]

Hi Fernando!

A pretty open question!

Here's something to consider.

Name the top left cell of your tables with the mode of transport.
Set up a data validation list of the modes of transport
Establish a data validation using the modes of transport list
Name the cell with the data validation drop down Choice
Use a Worksheet_Change event subroutine as follows:

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Me.Range("Choice")) Is Nothing Then Exit Sub
Dim MyTable As String
MyTable = Range("Choice").Value
Application.Goto Reference:=MyTable, Scroll:=True
End Sub


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.