Results 1 to 1 of 1

Radio Button in Dialog Box without UserForm

Threaded View

74256274 Radio Button in Dialog Box... 10-17-2012, 06:19 PM
  1. #1
    Registered User
    Join Date
    10-15-2012
    Location
    Palm Springs
    MS-Off Ver
    Excel 2002
    Posts
    2

    Radio Button in Dialog Box without UserForm

    I can't figure out how to use radio buttons for user input rather than typing in responses like I have below. I'd like the user to click on one of the four choices rather than typing them in. Thanks so much of your help!!!

    Sub FillEmpty()
    '
    ' Macro1 Macro
    ' Macro recorded 10/17/2012 by rnash
    '
    
    '
    Dim lw As Long
    Dim cell As Range
    Dim InputValue As String
    
       lw = Range("A" & Rows.Count).End(xlUp).Row
       Range("D1:D" & lw).Select
       
     On Error Resume Next
       InputValue = InputBox("1-1 FW Entrance" & vbCr & _
       "1-2 FW Exit" & vbCr & _
       "2-1 Hovley Entrance" & vbCr & _
       "2-2 Hovley Entrance II" & vbCr & _
       "3-1 Hovley Exit", _
       "Enter Location")
       For Each cell In Selection
       
       If IsEmpty(cell) Then
          cell.Value = InputValue
       End If
    Next
    End Sub

    Moderator Edit:

    Welcome to the forum, 74256274.

    Please notice that [CODE] tags have been added to your post. The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at the top of the page and read Rule #3.
    Thanks.
    Last edited by Cutter; 10-17-2012 at 09:09 PM. Reason: Added code tags

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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