+ Reply to Thread
Results 1 to 9 of 9

Append userform checkbox selection to cell

  1. #1
    Registered User
    Join Date
    04-18-2013
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    20

    Append userform checkbox selection to cell

    Hello all,
    This is my first post on this forum.
    Unfortunately, I’m not able to upload images from my work computer so I will try to explain best I can.
    In my worksheet, column F is named IT Equipment. When the user clicks the IT equipment button, a user form is displayed with four checkboxes – BlackBerry, Laptop, Workstation and other.
    I want the user to be able to select the correct equipment and save and close and the form. The selected items would be appended to cell F3 and would show with spacing and a comma – i.e. “BlackBerry, other”. The user would then continue to F4, F5 etc as the worksheet fills up.
    I hope this makes sense and thanks for your help.

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Append userform checkbox selection to cell

    Welcome to the board!

    Try this out.
    David
    (*) Reputation points appreciated.

  3. #3
    Registered User
    Join Date
    04-18-2013
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: Append userform checkbox selection to cell

    Works great!
    Thank you!

  4. #4
    Registered User
    Join Date
    04-08-2013
    Location
    Belgrade
    MS-Off Ver
    Excel 2013
    Posts
    15

    Re: Append userform checkbox selection to cell

    This is very similar to my request

    I need to have number intead string, is it posible to have input as number?
    example, if choose laptop, in cell to be written number 3, if choose other, in cell to be written number 4?

    I supose it is possible to have more then one form? (6 forms for 6 columns)

  5. #5
    Registered User
    Join Date
    04-08-2013
    Location
    Belgrade
    MS-Off Ver
    Excel 2013
    Posts
    15

    Re: Append userform checkbox selection to cell

    it could be even better
    in additional sheed (hiden one) to have cells
    Blackberry
    Laptop
    Other
    Workstation

    and if change it there, it is changed in user form?

  6. #6
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Append userform checkbox selection to cell

    Sure, just change the text to whatever you need.

    Please Login or Register  to view this content.
    I don't understand you're last question.

  7. #7
    Registered User
    Join Date
    04-08-2013
    Location
    Belgrade
    MS-Off Ver
    Excel 2013
    Posts
    15

    Re: Append userform checkbox selection to cell

    first at all thanks

    do you also need to change "String" ?

    Private Sub CommandButton1_Click()
    Dim Ctrl As Control
    Dim Ans As String[

    second question was than I do not need to put options in VB code (user form text for options 1, 2, 3, 4). I want that options description are in cells, whene I can change it wothout oppening VB code
    example, when you start excel from this example, it, when you click on F column field you get options to choose... description for that to be in cells a1 to a4 on another sheet

  8. #8
    Registered User
    Join Date
    04-08-2013
    Location
    Belgrade
    MS-Off Ver
    Excel 2013
    Posts
    15

    Re: Append userform checkbox selection to cell

    first at all thanks
    Last edited by sinisaj; 04-23-2013 at 01:33 PM. Reason: doubled post

  9. #9
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Append userform checkbox selection to cell

    Start a new thread. Upload a sample workbook showing your desired results.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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