+ Reply to Thread
Results 1 to 9 of 9

Radio Buttons/Check Boxes and Excel

Hybrid View

  1. #1
    Registered User
    Join Date
    04-03-2014
    Location
    us
    MS-Off Ver
    Excel 2003
    Posts
    7

    Radio Buttons/Check Boxes and Excel

    I was viewing this thread here: http://www.excelforum.com/excel-prog...readsheet.html

    It is a great solution, but I am unsure how to add checkboxes and radio buttons. If anyone can guide me to a tutorial or an example I would be happy to learn!

    I realised we should not ask for help in anothers thread, so I created my own.

  2. #2
    Registered User
    Join Date
    09-24-2013
    Location
    Twin Cities, MN
    MS-Off Ver
    Excel 2010
    Posts
    91

    Re: Radio Buttons/Check Boxes and Excel

    Try here:

    http://support.microsoft.com/kb/291073

  3. #3
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,239

    Re: Radio Buttons/Check Boxes and Excel

    I can't test it since I'm on a mac, but does this work?
    HTML Code: 

  4. #4
    Registered User
    Join Date
    04-03-2014
    Location
    us
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Radio Buttons/Check Boxes and Excel

    I'll be checking it out tomorrow. Thanks for getting to me. =]

  5. #5
    Registered User
    Join Date
    04-03-2014
    Location
    us
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Radio Buttons/Check Boxes and Excel

    Quote Originally Posted by Kyle123 View Post
    I can't test it since I'm on a mac, but does this work?
    Here is my code:
    HTML Code: 
    It runs but no value is put inside of the cell. Seems the main problem is assigning the value to the array?
    Last edited by Deepsplinter; 04-06-2014 at 07:50 PM.

  6. #6
    Registered User
    Join Date
    04-03-2014
    Location
    us
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Radio Buttons/Check Boxes and Excel

    Seems that I am getting a value of N/A.

    Also I noticed the form values should be numbered instead of all "2's" like this:

    HTML Code: 

  7. #7
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,239

    Re: Radio Buttons/Check Boxes and Excel

    What's in the worksheet? The code you posted assumes that there will be a column header for each field in sheet1 in cell a1

  8. #8
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,239

    Re: Radio Buttons/Check Boxes and Excel

    I couldn't even get vbscript running in IE11 - though it's still supported apparently, so here it is with JavaScript (tested and working)
    HTML Code: 

  9. #9
    Registered User
    Join Date
    04-03-2014
    Location
    us
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Radio Buttons/Check Boxes and Excel

    Quote Originally Posted by Kyle123 View Post
    I couldn't even get vbscript running in IE11 - though it's still supported apparently, so here it is with JavaScript (tested and working)
    Kyle,

    It's posting all of the data as needed, but when adding a new entry it overwrites previous entries as well as repeats the last question.
    I appreciate all of the help so far.

    Here is my current code and files:

    HTML Code: 
    1.xlsx

    As a side note I am saving the html code as a .hta file. It shouldn't cause any problems though.

+ 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. How to insert and user of Buttons, Radio buttons, check boxes in excel sheet.
    By krishco in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-03-2013, 02:52 AM
  2. How to insert Buttons, radio buttons and check boxes in Excel
    By krishco in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-01-2013, 08:13 AM
  3. Coding for Pop-up boxes based on responses to Yes/No Radio buttons
    By mkaur313 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-06-2012, 02:33 AM
  4. [SOLVED] how to get check boxes and radio buttons in excel?
    By all4excel in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-20-2007, 03:11 PM
  5. Check Boxes / Radio Buttons
    By tekman in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-26-2007, 12:52 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