I'm currently making a program that gives the person who uses it information about the costs for a shipment.
The transport company changes it numbers quite often, so in Excel the numbers are easier to change. I want to have, let's say, C3 be displayed every time in VB in the listbox, Holland, 500kg and a Postcal code is selected.
Does anyone know how I can achieve this?
Thanks in advance,
Here is a piece of code how it is right now:
If lstCountry = "Belgium" And lstWeight = "till 50kg" And lstPostal = "66-69" Then lstPrice.AddItem ("€ 47,00") lstTime.AddItem ("48 hours") End If
I would like it to be something like this:
If lstCountry = "Belgium" And lstWeight = "till 50kg" And lstPostal = "66-69" Then lstPrice.AddItem ("Sheet.Belg(C3)") lstTime.AddItem ("Sheet.Belg(C16)") End If