Active x, excel sheet form control

[erikgutten]

Hi there, all wizards.

Sitting here at work trying to build, for me way to comprehensive automated excel travel expense report form.

I dont know much about vba, so i'm lost, and i dont know wether i can get the controls to find what i would like in one table in different sheet. For if i choose one "country", i want a control to show this country in one base cell, then to collect corresponding amount in next set of colums, so that i can get the form to calculate as much as possible with less input from user.
That was problem nr 1

2 problem is
i like to use form control textbox to place data in different cells, telling 1: start date, 2: end date. third cell i want to calculate how many days it has been in between.
This i also want for calculating hours.

REason for this is to use these values as base to wether calculate in the findings with corresponding values in other sheet. When done with all my final layouts, and formulas i lock the form sheet, and leave only some cells open in sheet with reference tables.

[Bob Phillips]

Just create a table of country and country property data, use Data Validation in the country cell, and use Vlookup on country name to get the properties.

[erikgutten]

Just create a table of country and country property data, use Data Validation in the country cell, and use Vlookup on country name to get the properties.

Might work fine, if there is a way to get the list data from the sheet i need?
but can try som different ways to do just that, but not sure that i can easily use that if the sheet to be used in a webbased form later?

[erikgutten]

Might work fine, if there is a way to get the list data from the sheet i need?
but can try som different ways to do just that, but not sure that i can easily use that if the sheet to be used in a webbased form later?

Tried, the selection, or dropdown list isnt visible before selecting the cell, so that may not give the disered look. The look of the form control is prefered, an that is the more easy way to get the list like i want, which i've done in the sheet, but from selecting the desired country in that way, i dont know how to write the code to find the corresponding values for returned index n, or name in cell.