Results 1 to 3 of 3

Userform - Continue and cancel command buttons code

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-24-2009
    Location
    London, UK
    MS-Off Ver
    Excel 2007
    Posts
    178

    Userform - Continue and cancel command buttons code

    Hi all,

    I hope someone can help me please?

    I have my userform and currently it goes through my excel document and ticks a check box if the header is there (fantastic!).
    I am hoping to add two command buttons to the end to allow the user to continue with the macro or cancel the macro and return to the workbook but I am struggling with the code I need for this - could someone please advise me on this?

    Below is the code for the check boxes which I will need to add to for my other two buttons.

    Thanks for your help.


    
    Private Sub UserForm_Initialize()
    
      c01 = "|" & LCase(Join(Application.Transpose(Application.Transpose(Rows(1).SpecialCells(2))), "|")) & "|"
      For j = 1 To 10
        Me("Checkbox" & j) = InStr(c01, "|" & LCase(Me("Checkbox" & j).Caption) & "|") > 0
      Next
    End Sub
    Last edited by Jessica.Bush; 09-01-2010 at 04:43 PM.

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