+ Reply to Thread
Results 1 to 4 of 4

Active x, excel sheet form control

  1. #1
    Registered User
    Join Date
    08-13-2010
    Location
    Norway, Oslo
    MS-Off Ver
    Excel 2007
    Posts
    3

    Question Active x, excel sheet form control

    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.
    Attached Files Attached Files

  2. #2
    Forum Guru Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,286

    Re: Active x, excel sheet form control

    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.

  3. #3
    Registered User
    Join Date
    08-13-2010
    Location
    Norway, Oslo
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Active x, excel sheet form control

    Quote Originally Posted by Bob Phillips View Post
    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?

  4. #4
    Registered User
    Join Date
    08-13-2010
    Location
    Norway, Oslo
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Active x, excel sheet form control

    Quote Originally Posted by erikgutten View Post
    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1