Results 1 to 10 of 10

Thread: Disable TextBoxes and imput the correct data Based on ComboBox Choice

  1. #1

    Disable TextBoxes and imput the correct data Based on ComboBox Choice



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

    Hi all,

    I am having some problems on blocking some textboxes, depending the choice of made on the combobox (cboTM), i could do well for "Material" but for "Worklabor" and "equipments", only the opaque didnt worked


    the other thing was, how i put the correct info on the texboxes :



    if i choose "materials" from cboTM, and option 1 ("B7") from cboDM, textemp and textHours will become blocked and the dada from the sheet "material" will appear on the textboxes like that:

    (sheet Material)

    textmeasure ="C7"
    textQuant="D7"
    textprice="E7"
    texttprice="F7"


    same to Worklabor :

    if i choose "worklabor" from cboTM, and option 1 ("B7") from cboDM, textQuant will become blocked and the dada from the sheet "worklabor" will appear on the textboxes like that:

    (sheet Worklabor)

    textmeasure ="C7"
    textemp="D7"
    textHours="E7"
    textprice="F7"
    texttprice="G7"


    and the same for Equipents....etc..


    file attacked.
    Attached Files Attached Files
    Last edited by TomBeaver; 2014-03-25 at 12:34 PM.

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,479
    Articles
    0
    Excel Version
    365

  3. #3
    well, yes its the same, i need an answer, and in more forums, more chances of getting one.

    however, now i only need to know how i can put the right data in the right textboxes.
    The listindex its confusing me.

  4. #4

  5. #5
    For what i know, this forum its not the same as the other.

    And if you dont want to help, then stop filling with rubbish.

  6. #6
    Super Moderator Zack Barresse's Avatar
    Join Date
    Mar 2011
    Location
    Oregon, United States
    Posts
    106
    Articles
    0
    Tom,

    As it appears you may not have known the forum rules, or the proper netiquette of posting to forums, your thread will not be deleted and you won't be banned. Be warned, however, due diligence on your part of reading the thread p45cal linked regarding cross posting, as well as posting any subsequent cross-posted links, will need to be done in the future. It may not seem like much to you, but when people waste their time (which is what they're doing if another expert is working on the same thing) they're not too keen on helping in the future. This is a community, and many members post to other forums (as you should well know).

    Give the link a read. If you do cross-post (because your point is valid - more forums, more help) you must include such links in any other threads of the same topic/issue. Ken did a good job of explaining this in the linked post.

    Edit: Oh, and it helps to not be rude about it as well. That won't get you very far either.
    Regards,
    Zack Barresse

  7. #7
    Administrator Simon Lloyd's Avatar
    Join Date
    Apr 2011
    Location
    Manchester, England
    Posts
    370
    Articles
    0
    Excel Version
    Excel 2016
    Quote Originally Posted by TomBeaver View Post
    For what i know, this forum its not the same as the other.

    And if you dont want to help, then stop filling with rubbish.
    Firstly every forum has a crossposting rule and we respectfully ask that you follow ours. Secondly, p45cal is a well respected member of many forums and quite rightly, and politely pointed out that you have crossposted and why and how this could be done respctfully.

    P45cal has not posted rubbish nor has he declined to help (up to this point) so please keep a level of decorum.

    As this question is currently being answered at other locations i'm closing it, if you want to post a nother question please feel free but do follow our rules and we'll be glad to help.
    Kind regards,
    Simon Lloyd
    Microsoft Office Discussion

  8. #8
    Administrator Simon Lloyd's Avatar
    Join Date
    Apr 2011
    Location
    Manchester, England
    Posts
    370
    Articles
    0
    Excel Version
    Excel 2016
    Woah, didnt see your toes there as i was creating my post
    Kind regards,
    Simon Lloyd
    Microsoft Office Discussion

  9. #9
    Super Moderator Zack Barresse's Avatar
    Join Date
    Mar 2011
    Location
    Oregon, United States
    Posts
    106
    Articles
    0
    Ha! Sorry Simon. At least we were on the same page!
    Regards,
    Zack Barresse

  10. #10
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,271
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Quote Originally Posted by Zack Barresse View Post
    Ha! Sorry Simon. At least we were on the same page!
    I think that, on this topic, you'd be hard pressed to find a prolific forum poster who is NOT on the same page!
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Posting Permissions

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