+ Reply to Thread
Results 1 to 3 of 3

Dropdown list not show data in F22 in my sheets for Quote

  1. #1
    Forum Contributor
    Join Date
    09-03-2008
    Location
    Johannesburg, South Africa
    MS-Off Ver
    2021
    Posts
    351

    Dropdown list not show data in F22 in my sheets for Quote

    I am using this excel vb code to show info on my sheets

    I am using the same 2 dropdown list for two different sheet one is in English and one in Afrikaans.
    So when I add a new entry in "Kwotasie, you can press the dropdown and choose it in both and it will show you the value in F22 and down,
    but when you add new data from Quote, it does not show value in both sheets for F22 and down

    I am not sure what the problem can be

    Using Sheet1(Kwotasie) and sheet 2(Quote)
    main sheets were the dropdown lists are Kwotasie and Quote, get data from F22 from Dienste and Services

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by hendrikbez; 04-28-2024 at 12:57 PM.

  2. #2
    Forum Contributor
    Join Date
    09-03-2008
    Location
    Johannesburg, South Africa
    MS-Off Ver
    2021
    Posts
    351

    Re: Dropdown list not show data in F22 in my sheets for Quote

    Got it to work, Did have wrong name in my formula!

  3. #3
    Forum Expert
    Join Date
    11-28-2015
    Location
    indo
    MS-Off Ver
    2016 64 bitt
    Posts
    1,513

    Re: Dropdown list not show data in F22 in my sheets for Quote

    You has using double if should be one is elseif, or check for set ws is correct name of sheet
    Please Login or Register  to view this content.
    Last edited by daboho; 04-28-2024 at 01:36 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Show a conditional dropdown list of data validation only if a specific cell equals a value
    By jeriss in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-19-2022, 01:24 PM
  2. [SOLVED] Data Extraction from Other Sheets Based on the Value from the Dropdown List
    By franceslin in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 09-13-2021, 11:55 AM
  3. Show a list of data based from dropdown selection
    By reecerito in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-09-2016, 03:18 AM
  4. Replies: 2
    Last Post: 03-31-2014, 01:32 AM
  5. Retrieve Data from other sheets using dropdown list.
    By lemuel in forum Excel General
    Replies: 8
    Last Post: 09-28-2012, 09:35 AM
  6. Making a data list from a separate quote sheets
    By Benjando in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-08-2010, 12:19 AM
  7. Replies: 6
    Last Post: 07-17-2009, 01:35 PM

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