Results 1 to 10 of 25

Thread: changing code from using Combobox to optionbuttons

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #6
    Senior Member
    Join Date
    Jun 2012
    Posts
    337
    Rep Power
    14
    You'd better remove all merged cells.
    in the userform machine stoppage this will suffice in the initialize event:

    Code:
    Private Sub UserForm_Initialize()
        ComboBox1.List = [transpose(text(today()-3+row(1:5),"dd-mmm-yyyy"))]
        
        sn = Sheets("INFO").Cells(3, 3).CurrentRegion.Offset(2)
        For j = 2 To 6
          Me("combobox" & j).List = Application.Index(sn, 0, j - 1)
        Next
    End Sub
    NB posting a non protected sample workbook would help the helpers a lot !
    Last edited by snb; 09-02-2013 at 04:55 PM.

Similar Threads

  1. Replies: 8
    Last Post: 08-17-2013, 04:03 AM
  2. Changing Picture Using Data Validation
    By jeff in forum Excel Help
    Replies: 3
    Last Post: 08-03-2013, 09:39 AM
  3. adding entries into combobox with code
    By paul_pearson in forum Excel Help
    Replies: 1
    Last Post: 07-23-2013, 01:01 PM
  4. Changing Slideshow viewing mode to kiosk using vba
    By Times in forum Powerpoint Help
    Replies: 1
    Last Post: 05-10-2013, 12:37 AM
  5. Changing Hyperlink To Another Sheet By Changing Value Of Cell
    By Excel Fox in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 04-30-2011, 11:55 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •