Results 1 to 5 of 5

UserForm Data Entry with Option Buttons

Threaded View

  1. #1
    Registered User
    Join Date
    10-26-2013
    Location
    New York
    MS-Off Ver
    Excel 2007
    Posts
    11

    UserForm Data Entry with Option Buttons

    I am creating a UserForm that has multiple fields in it, such as textboxes, comboboxes, and more. Here is my code right now where I have a combobox that has its data entered into a sheet once a command button is clicked:

    Private Sub CommandButton1_Click()
    
       Dim ssheet As Worksheet
       Set ssheet = ThisWorkbook.Sheets("Calculator")
       nr = ssheet.Cells(Rows.Count, 1).End(xlUp).Row + 1
       ssheet.Cells(nr, 1) = Me.cboBusiness
    
    End Sub

    I was wondering, given a group of option buttons, how could I get the selected option button's value inserted into my sheet? I have been searching quite a bit for this answer but haven't found much besides some very complex code. Thank you.
    Last edited by 6StringJazzer; 10-26-2013 at 01:51 PM. Reason: Added code tags

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Populate userform radio (option) buttons based on data in worksheet
    By d.sanchez in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-24-2013, 01:21 PM
  2. [SOLVED] Option Box buttons in UserForm help
    By motolich in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-28-2013, 12:04 AM
  3. UserForm with option buttons for a survey
    By JimmyG. in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-22-2013, 06:15 AM
  4. Userform Summing Option buttons
    By flebber in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 09-23-2010, 08:21 AM
  5. Help with a option buttons located in a userform
    By mav93 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-01-2006, 01:40 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