+ Reply to Thread
Results 1 to 12 of 12

Dropdown box gets a value ...then labels change to certain database rows ...[sheets1;2]

  1. 02-06-2014, 07:56 AM #1
    kasharis
    kasharis is offline
    Registered User
    Join Date
    12-09-2013
    Location
    Home
    MS-Off Ver
    Ms 2010
    Posts
    32

    Question Dropdown box gets a value ...then labels change to certain database rows ...[sheets1;2]

    Hello!
    I got a question .. i got an Active X dropdown box ... and got a simple database .... and some 5 labels
    from sheet1 i got from A2 till F2 a certain nummbers but there are text that would show up to sheet 2 dropbox
    i guess text or nummbers from A2 that would show up in dropdown box....
    And when i chose that one Thats in Dropdownbox then Labels [Label1;label2;label3;label;4;label5;] Change their name
    to that row A2 till F2. But when i will use some information in (i guess) A3 Till F3 then it will show up and change labels to that one ...
    Would be happy if i could get a code
    Tell me if you need a sample document !

    UPDATE I've Been uploading a sample doccument [Macro-enabled]
    Hope you can help me solve this problem!
    1.xlsm
    Last edited by kasharis; 02-07-2014 at 03:22 AM. Reason: Upload a sample file!
    Reply With QuoteRegister To Reply
  2. 02-07-2014, 01:57 AM #2
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Dropdown box gets a value ...then labels change to certain database rows ...[sheets1;2

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved

    If the suggestion helps you, then Click *below to Add Reputation
    Reply With QuoteRegister To Reply
  3. 02-07-2014, 03:24 AM #3
    kasharis
    kasharis is offline
    Registered User
    Join Date
    12-09-2013
    Location
    Home
    MS-Off Ver
    Ms 2010
    Posts
    32

    Re: Dropdown box gets a value ...then labels change to certain database rows ...[sheets1;2

    Bump!
    I've uploaded a sample file !
    the thing is really basic
    Reply With QuoteRegister To Reply
  4. 02-07-2014, 04:55 AM #4
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Dropdown box gets a value ...then labels change to certain database rows ...[sheets1;2

    Just one more question :conused:

    Label3 refers to which column?

    Label7 refers to which column?
    Reply With QuoteRegister To Reply
  5. 02-07-2014, 05:02 AM #5
    kasharis
    kasharis is offline
    Registered User
    Join Date
    12-09-2013
    Location
    Home
    MS-Off Ver
    Ms 2010
    Posts
    32

    Re: Dropdown box gets a value ...then labels change to certain database rows ...[sheets1;2

    Quote Originally Posted by :) Sixthsense :) View Post
    Just one more question :conused:

    Label3 refers to which column?

    Label7 refers to which column?
    Label 3 = 1B;2B;3B;4B;5B;6B till 15
    And label 7 = From 1F till 15F
    i hope you can understand what i was meaning about this
    just straight line down! For each one
    so when you finish then you can easy read ....
    Reply With QuoteRegister To Reply
  6. 02-07-2014, 05:42 AM #6
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Dropdown box gets a value ...then labels change to certain database rows ...[sheets1;2

    Check whether this helps you
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 02-07-2014, 05:46 AM #7
    kasharis
    kasharis is offline
    Registered User
    Join Date
    12-09-2013
    Location
    Home
    MS-Off Ver
    Ms 2010
    Posts
    32

    Re: Dropdown box gets a value ...then labels change to certain database rows ...[sheets1;2

    hmmmm strange.... i wanted to use the nummbers as a marking to dropdown box ... if you understand ... thats why i wrote a nummber list Hoping maybe can correct it
    Will try to understand !
    UPDATE : ADDED A IMAGE !
    understanding111.jpg
    Last edited by kasharis; 02-07-2014 at 05:57 AM. Reason: Added a image!
    Reply With QuoteRegister To Reply
  8. 02-07-2014, 05:54 AM #8
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Dropdown box gets a value ...then labels change to certain database rows ...[sheets1;2

    Check this revised file
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  9. 02-07-2014, 05:59 AM #9
    kasharis
    kasharis is offline
    Registered User
    Join Date
    12-09-2013
    Location
    Home
    MS-Off Ver
    Ms 2010
    Posts
    32

    Re: Dropdown box gets a value ...then labels change to certain database rows ...[sheets1;2

    please check image what i added so you can understand!
    Reply With QuoteRegister To Reply
  10. 02-07-2014, 06:02 AM #10
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Dropdown box gets a value ...then labels change to certain database rows ...[sheets1;2

    Sorry I tried my level best to solve it but I am unable to understand your requirement and I hope someone will take care of this thread
    Reply With QuoteRegister To Reply
  11. 02-07-2014, 06:08 AM #11
    kasharis
    kasharis is offline
    Registered User
    Join Date
    12-09-2013
    Location
    Home
    MS-Off Ver
    Ms 2010
    Posts
    32

    Re: Dropdown box gets a value ...then labels change to certain database rows ...[sheets1;2

    you did first time good ... but you bit got wrong when you used col ...
    it just needed a nummber ! hope you can understand
    will try to solve it
    if you chose from a dropdownbox a nummber thats from A1 till A15 then the nummbers show in dropdown box ...
    for each label it changes
    Label - From row 2 till row 15
    maybe you know the answer ..
    Reply With QuoteRegister To Reply
  12. 02-08-2014, 04:57 PM #12
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Dropdown box gets a value ...then labels change to certain database rows ...[sheets1;2

    Hi kasharis

    Let's see if this is approaching what you're looking for...if so, we can develop it further... 
    Please Login or Register  to view this content.
    Attached Files Attached Files
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. creating a dropdown dynamically in multiple rows & assiging values to it from database
    By svibuk in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-03-2013, 03:12 AM
  2. Associating Labels in a Dropdown List with Data
    By pandaman in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 12-15-2010, 08:32 PM
  3. Dropdown menu, item labels
    By Jeff S in forum Excel General
    Replies: 2
    Last Post: 11-19-2009, 10:20 AM
  4. [SOLVED] Worksheet change code to colour in rows in a database
    By Peter Rooney in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-19-2006, 06:40 AM
  5. Database onto A4 address labels
    By Arfur Bittah in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 01-17-2006, 07:50 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1