+ Reply to Thread
Results 1 to 4 of 4

Running a Userform on EXCEL sheet?

  1. #1
    dvoit91
    Guest

    Running a Userform on EXCEL sheet?

    Hello there, I have programmed a Userform to be generated on to my Excel Spreadsheet 2 from the click of an inserted button.

    For some reason, after I click this button to Run my userform,
    it gives me a message like this,


    Run-time error '2110':

    Can't move focus to the control because it is invisible, not enabled, or
    of a type that does not accept the focus.


    I'm not quite sure what is wrong with it ,
    Could anyone please help it run again!?
    and if so,
    I have attached this file to help explain it

    - Thanks for the Help!
    Attached Files Attached Files

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,295

    Re: Running a Userform on EXCEL sheet?

    Hi dvoit91,

    Try the attached.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    dvoit91
    Guest

    Re: Running a Userform on EXCEL sheet?

    For some reason I am not sure what to do with what you just posted,

    I am still getting an error because I am not sure what needs to be corrected here.

    On my Userform that displays when opening the project,
    I need to have my CommandButton 5 ( the NEXT button on page 2 of userform)
    send me to the nextpage.

    Please explain how to fix this error

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,295

    Re: Running a Userform on EXCEL sheet?

    Hi try this attached.

    The first tab is zero. I've added code for your next, previous and close buttons.
    Attached Files Attached Files

+ Reply to Thread

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