+ Reply to Thread
Results 1 to 4 of 4

Calling ComboBoxs created on the fly

  1. #1
    Registered User
    Join Date
    09-17-2010
    Location
    Manchester, England
    MS-Off Ver
    Excel 2007
    Posts
    2

    Calling ComboBoxs created on the fly

    Hi,

    I am new to this forum so please forgive me if this is a simple question.

    I have a multi-page userform and I create some of the pages and comboboxes on the fly, I want to reference these combo boxes and have the following code
    Please Login or Register  to view this content.
    (The above works however I need to access various comboboxes so need to change the name of the combobox in a while loop)

    I tried this but it does not work, (where Z is an integer representing the Combobox I want) Even when I set Z to one it does not run.
    Please Login or Register  to view this content.
    Any Ideas, thanks

    James
    Last edited by Oak_16; 09-17-2010 at 09:02 AM. Reason: add code tags

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Calling ComboBoxs created on the fly

    Try:
    Please Login or Register  to view this content.
    Note: when posting code, please use code tags. I've added them for you this time as it's your first post, but you must use them in future.

    Thanks.
    Remember what the dormouse said
    Feed your head

  3. #3
    Registered User
    Join Date
    09-17-2010
    Location
    Manchester, England
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Calling ComboBoxs created on the fly

    Thanks for your help, that worked a treat.
    Sorry for not using the code tags, will try to remember in future.
    Thanks
    James
    PS How do I add the Solved prefix to the subject line?
    Last edited by Oak_16; 09-17-2010 at 07:06 AM.

  4. #4
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Calling ComboBoxs created on the fly

    (Canned response below )

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save

+ 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