+ Reply to Thread
Results 1 to 11 of 11

Place X in correct column according to checkbox selects on form

  1. #1
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    505

    Place X in correct column according to checkbox selects on form

    I need two things:
    1) According to checkbox's selected, put in the same column Name in Worksheets("Tapasois") the word "SIM" OR X ( At the end of the "ENVELOPES" Sheet - although this needs to be able to introduce new columns and then adjust programmation)
    Let me better explain:

    In Sheet2 i have a table, and in somecolumns i have the production sections ("Bolha, Embalagem , Serigrafia, etc etc") - Which i have too in the Checkbox's Caption
    What i need is, according to checkbox's selected put the word "SIM" in the last filled row in Sheet2 columns of the section.

    Probably i can do this with IF Checkbox1.Value = True then put in Cell X the word "SIM" put let me know if there is a better way.

    My 2nd need would be to change a little bit the Msgbox of the checkbox's select

    The Checkbox's are according to Master Sections like, "Production , expedition , packaging"
    Checkbox1 , 2 , 4 are from Production
    Check 3 , 5,8 are from expedition
    Checkbox 6,7 are from packaging

    Display a Msgbox saying according to checking box value:
    "The following sections were printout"

    From Production:
    Checkbox1.caption
    Checkbox2.caption

    Expedition:
    None

    Packaging:
    Checkbox7

    This is an exemple for Check1,2 and 7 pressed.

    File is attached, hope someone can help me out
    Thank you very much for your help in advance.
    Attached Files Attached Files
    Last edited by brainzlp; 11-15-2015 at 07:25 AM.

  2. #2
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    505

    Re: Place X in correct column according to checkbox selects on form

    If someone has questions about my file please contact me.

    I really need this to apply in my file.

  3. #3
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    505

    Re: Place X in correct column according to checkbox selects on form

    Is there any Excel expert willing to help me with this problem that will make my program way simpler.

    Hope to hear from you asap
    Last edited by brainzlp; 12-02-2015 at 01:58 PM.

  4. #4
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    505

    Re: Place X in correct column according to checkbox selects on form

    Noone able to share knowledge in this matter? Hope some expert can help me out. The 1st problem is the most needed.

  5. #5
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    505

    Re: Place X in correct column according to checkbox selects on form

    Am i doing something wrong? Do i need to place my question in a different section?

    Hope to hear from someway as soon as possible.

  6. #6
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,551

    Re: Place X in correct column according to checkbox selects on form

    Sorry I'm having a hard time understanding your explanation of what you want.

    Studying your workbook isn't making it any clearer.
    Last edited by skywriter; 12-14-2015 at 12:49 PM.
    As a reminder, once your original request has been fulfilled please mark this thread as SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

    If you are happy with my help, then please consider clicking the add reputation button in the lower left hand corner of this post.

  7. #7
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    505

    Re: Place X in correct column according to checkbox selects on form

    1st of all, the thread as a workbook attached, if you download it. you can check u'll see.

    No problem, i'll try to figured it out.

    Thanks for your help

  8. #8
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,551

    Re: Place X in correct column according to checkbox selects on form

    I changed post #6.
    Now it has nothing specific.
    Good luck.

    Quote Originally Posted by brainzlp View Post
    1st of all, the thread as a workbook attached, if you download it. you can check u'll see.

    No problem, i'll try to figured it out.

    Thanks for your help

  9. #9
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    505

    Re: Place X in correct column according to checkbox selects on form

    I solved it, with manual input. Forget it.

  10. #10
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,551

    Re: Place X in correct column according to checkbox selects on form

    Forgotten.

    Quote Originally Posted by brainzlp View Post
    I solved it, with manual input. Forget it.

  11. #11
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    505

    Re: Place X in correct column according to checkbox selects on form

    Quote Originally Posted by skywriter View Post
    Forgotten.
    If possible give me help in : http://www.excelforum.com/excel-prog...ml#post4268543

    I have attached file and explanation.

    Hope you can help me out

+ 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. Checkbox on a Userform that selects all entries of a Listbox
    By dutchcourage in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-17-2015, 08:09 AM
  2. Need macro to fetch value when a user selects a checkbox
    By santnair0599 in forum Excel General
    Replies: 2
    Last Post: 05-30-2015, 01:04 PM
  3. Replies: 15
    Last Post: 11-25-2014, 08:14 AM
  4. [SOLVED] Is there a way to add a button that selects the next checkbox in a row?
    By R_Bish in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-04-2014, 05:42 PM
  5. One checkbox that selects multiple checkboxes
    By pozmoney in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-25-2013, 05:57 PM
  6. Enter text value into next availble cell in range if user selects correct answer
    By jerbaldw in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-18-2012, 10:24 AM
  7. [SOLVED] pause macro until user selects correct range
    By JCIrish in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-18-2006, 05:30 PM

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