Results 1 to 7 of 7

Thread: VBA Programming - Somethings gone wrong!!!!!!

  1. #1

    Exclamation VBA Programming - Somethings gone wrong!!!!!!



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have an excel spreadsheet set up with certain minor programming elements, one of which is the dropdown boxes for Country, County and Local Authority. this was all working fine until i amended the form to include additional information required.

    I had assistance in programming the dropdowns originally from a colleague who no longer works for the company and now cannot seem to fix them.

    Can someone please assist!!!!
    Attached Files Attached Files

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,829
    Articles
    0
    Excel Version
    O365
    It would be helpful if you could give us a clue, what is the high-level concept, what was happening that doesn't work now, what did you change that broke it.

  3. #3
    Bob,

    Our client are useless at providing the straight forward information regarding tenders.

    We currently have a very basic format which they cannot seem to fathom requires completion before i have the information required therefore i have (with some assistance) produced this format which gives the client drop down boxes, tick boxes etc to complete so that we get what we want and they get the correctly priced tender return at the end of it.

    The 3 drop down boxes are meant to work as follows

    Dropdown 1 (Country) is straight forward and gives the option to select from "England, Ireland, Scotland & Wales"

    Dropdown 2 (County) is supposed to take the information provided from DD1 and give a further list of options regarding which County the works takes place in.

    Dropdown 3 (Local Authority) is then meant to take the information from DD2 and provide the client with a list of Local Authorities (Various Councils) so that they may pick the most appropriate for the location of the works

    for example

    DD1 - England
    --> DD2 - London
    -->DDŁ - London Borough of Barnet

  4. #4
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,829
    Articles
    0
    Excel Version
    O365
    I've more or less figured it all, but what should happen when the LA is selected?

  5. #5
    The LA doesnt affect the sheet, this is purely to give us details of which authority they are currently dealing with.

    Originally i was going to use the selections in these drop-downs to automatically input the Local Construction Normal Working Hours.

  6. #6
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,829
    Articles
    0
    Excel Version
    O365
    Try this

  7. #7
    Cheers Bob

    Much Appreciated

Posting Permissions

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