+ Reply to Thread
Results 1 to 16 of 16

I want to put some sheets in the combo box

  1. #1
    Registered User
    Join Date
    06-21-2022
    Location
    eg
    MS-Off Ver
    2010
    Posts
    9

    Question I want to put some sheets in the combo box

    please I want to put some items in the combo box?

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: I want to put some sheets in the combo box

    أهلا وسهلا‎ Welcome to the Forum netyasser!

    Please provide MUCH more detail.

    Is the combobox on a worksheet, or a UserForm?

    What exactly do you want to put in the combobox?

    Consider attaching your file. See yellow banner at the top of the page.
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    06-21-2022
    Location
    eg
    MS-Off Ver
    2010
    Posts
    9

    Re: I want to put some sheets in the combo box

    I want to put some of work sheets
    Like
    Sheet1
    Sheet2
    Sheet3
    Not all sheets

  4. #4
    Registered User
    Join Date
    06-21-2022
    Location
    eg
    MS-Off Ver
    2010
    Posts
    9

    Re: I want to put some sheets in the combo box

    In userform

  5. #5
    Forum Contributor
    Join Date
    02-08-2021
    Location
    africa
    MS-Off Ver
    2016
    Posts
    387

    Re: I want to put some sheets in the combo box

    @netyasser
    you can try this
    Please Login or Register  to view this content.

  6. #6
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: I want to put some sheets in the combo box

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Torachan,

    Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.

  7. #7
    Registered User
    Join Date
    06-21-2022
    Location
    eg
    MS-Off Ver
    2010
    Posts
    9

    Re: I want to put some sheets in the combo box

    thanks
    But why do I choose it dident go to sheet1 or to ?

  8. #8
    Registered User
    Join Date
    06-21-2022
    Location
    eg
    MS-Off Ver
    2010
    Posts
    9

    Re: I want to put some sheets in the combo box

    Quote Originally Posted by torachan View Post
    Please Login or Register  to view this content.
    thanks
    But why do I choose it dident go to sheet1 or to ?

  9. #9
    Forum Contributor
    Join Date
    02-08-2021
    Location
    africa
    MS-Off Ver
    2016
    Posts
    387

    Re: I want to put some sheets in the combo box

    sorry !
    add to this userform module
    Please Login or Register  to view this content.

  10. #10
    Registered User
    Join Date
    06-21-2022
    Location
    eg
    MS-Off Ver
    2010
    Posts
    9

    Re: I want to put some sheets in the combo box

    Quote Originally Posted by MKLAQ View Post
    sorry !
    add to this userform module
    Please Login or Register  to view this content.
    thanks very much
    it works

  11. #11
    Forum Contributor
    Join Date
    02-08-2021
    Location
    africa
    MS-Off Ver
    2016
    Posts
    387

    Re: I want to put some sheets in the combo box

    your very welcome
    if this is solved please mark solved

  12. #12
    Registered User
    Join Date
    06-21-2022
    Location
    eg
    MS-Off Ver
    2010
    Posts
    9

    Re: I want to put some sheets in the combo box

    Quote Originally Posted by MKLAQ View Post
    your very welcome
    if this is solved please mark solved
    please if I want 3 combo box what code?

  13. #13
    Forum Contributor
    Join Date
    02-08-2021
    Location
    africa
    MS-Off Ver
    2016
    Posts
    387

    Re: I want to put some sheets in the combo box

    this is not your question in OP .
    you don't want to attach file and when your thread has been solved you mark solved and suddenly you mark unsolved . now you ask new requirements.
    it's unfair
    may be else body help you .
    good luck

  14. #14
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: I want to put some sheets in the combo box

    come on - put a bit of effort in - use a bit of logic

    Please Login or Register  to view this content.

  15. #15
    Registered User
    Join Date
    06-21-2022
    Location
    eg
    MS-Off Ver
    2010
    Posts
    9

    Re: I want to put some sheets in the combo box

    Quote Originally Posted by MKLAQ View Post
    this is not your question in OP .
    you don't want to attach file and when your thread has been solved you mark solved and suddenly you mark unsolved . now you ask new requirements.
    it's unfair
    may be else body help you .
    good luck
    I'm sorry, but the question is related to the previous one

  16. #16
    Registered User
    Join Date
    06-21-2022
    Location
    eg
    MS-Off Ver
    2010
    Posts
    9

    Re: I want to put some sheets in the combo box

    I get it
    Private Sub UserForm_Initialize()
    ComboBox1.List = Array("sheet1","sheet2","sheet3")
    ComboBox2.List = Array("sheet1","sheet2","sheet3")
    ComboBox3.List = Array("sheet1","sheet2","sheet3")
    End Sub

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Combo Box Displaying on Other Sheets
    By Azurulean in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-20-2021, 08:54 AM
  2. [SOLVED] Excel 2010 VBA – Combo Box Options– Clear cell/box in 2nd Combo when 1st Combo selected
    By theshybutterfly in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-17-2013, 07:25 PM
  3. [SOLVED] Combo Box to select sheets
    By lukestkd in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-08-2013, 05:53 PM
  4. [SOLVED] Combo Box with Clickable Different Sheets!
    By earthworm in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 06-01-2009, 10:09 AM
  5. Using a combo box to navigate between sheets
    By Shieldsy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-12-2008, 08:30 AM
  6. Combo Box To Jump Between Sheets
    By vivek_1612 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-16-2007, 10:46 AM
  7. [SOLVED] Adding Sheets to a combo Box
    By David Pick in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-16-2005, 05:05 PM

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