Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

Select Multiple Items in a ComboBox (VBA) ???

Given that I have a combobox that shows all of the files on my floppy disk, I would like the user to be able to select multiple files from this disk for an action to be done to just those files.

Does anyone know how this can be done, if it is at all possible ? If not, is there any work-around using a different technique or has anyone used a different method to achieve the same ends ???

Thanks

TO.


Post your answer or comment

comments powered by Disqus
Hi,

I am using the autofilter option in Excel and want to be able to select various items in a column/list. Can I do this through Excel directly or do I need to use code?

Thanks

Jodie

Hello! First, thanks for any help anyone can send my way - it will be appreciated!
I haev 700+ pivot table files built in Excel 2003. My company recently upgraded to 2007. I've developed an extensive macro tool to "upconvert" all my files to Excel 2007. However, there's one piece yet that I just can't figure out!
In the PageFields of my pivot table, it defaults to allowing the user to "Select Multiple Items." I need to have this option unchecked - without having to do it by hand on the 700+ files.
I've found this piece of code:
ActiveSheet.PivotTables("PivotTable1").PivotFields("Geographies") _
.EnableMultiplePageItems = False
However, it seems to have no effect. I think my problem might be that i'm not using cube/olap/etc type data - just regular excel data. From what I've been able to find, the enablemultiplepgeitems property only works with those types of source data. What am I missing??
Thanks!!

Well, I figured it out:
    With ActiveSheet.PivotTables("PivotTable1").PivotFields("Geographies")
        .PivotItems("(blank)").Visible = True
    End With
    ActiveSheet.PivotTables("PivotTable1").PivotFields("Geographies"). _
        EnableMultiplePageItems = False
    ActiveSheet.PivotTables("PivotTable1").PivotFields("Geographies").CurrentPage = _
        "(All)"
In 2003, we had hidden "blank." In 2007, blank was visible, but uncheck. So, I wrote the code to check blank, then disable the Multiple Items. Worked like a charm...

Hi All

I have bulit a userform in which there is one combobox that stores the values present in a column in excel sheet. Now my problem is when I process one item ,I want to remove that item from a combobox although it is present in excel sheet.

How to remove the selected item in a combobox..Could anyone please provide me vba code for this

Regards
Aman

Hi, this code isn't working:
How to do it or something like:
Ie, how to show a specific item in a combobox.

I need some help selecting multiple columns in a named selection,
something similar to vlookup but for more than one column/result.

--
Griffithpt
------------------------------------------------------------------------
Griffithpt's Profile: http://www.excelforum.com/member.php...o&userid=37304
View this thread: http://www.excelforum.com/showthread...hreadid=570153

Excel 2007 SP2 crashes when attempting to select multiple values in a pivot with lot of values

Hello,
I have a problem with both Excel 2003 and Excel 2007.
We work with a pivot table sourced from a Analysis Services cube.
When I put the dimension attribute in the row area and try to select multiple values I get a bug.
In Excel 2007, the bug will happen only if the list has many values (17000 in this case)
If I select 2 or 3 or more values in the list, Excel 2007 SP2 crashes immediately.

With Excel 2003 SP3, the bug is different, it simply ignore the multiple select and always shows everything. Furthermore, there is a private hotfix kb947648-fix that repairs this bug.

Is there any hotfix to repair the Excel2007 version of this bug?
Thanks,
PhilippeThanks/Regards,Philippe Cand

Can somebody please provide a brief example of how to sort items in a
combobox? I retrieve the items from an Excel range on a worksheet but I
can't sort in the sheet as these values are part of an other sorted list.

I need some help selecting multiple columns in a named selection, something similar to vlookup but for more than one column/result.

Thank you in advance.

Good mornngs,

I've searched for a topic to cover this but could not find one so....

Is it possible to restrict the values of cells in a particular column to entries defined in a list BUT to allow each cell in that column to display multiple items from the list (seperated by a comma for example)

I've attached an example of what I would like to do -

In Sheet "2010 Data" I want to be able to select multiple values in column F....(the values are defined within the list named "Platforms" on the worksheet called "Lookups"

Thanks in advance !

dan

I am trying to set up data validation lists where you can select multiple
items from the data validation dropdowns in the column and items are added to
the active cell in that same column, separated by a comma.

I have a simple Bar Chart, and can't seem to figure out if there is a
way to select, say 5 of the bars and apply color formatting to those 5
all at once. I can select all, and then on the next mouse click, I
can select an individual bar, but in holding down the CTRL, SHIFT, and
ALT keys, I cannot seem to select mutiple items. Is this possible?
Maybe I am trying to group them for formatting purposes.

Thanks,
Brooks

I have a field that is "outside" the data area and I only want to select
certain items to view. If that field box is "inside" the data area, then it
lets me do it. Is there a trick to select multiple items like in Excel 2007?

Dear All,

Column A to Z is 1 language.
Column AA to AZ is the same data in another language.

F12 is a combobox ( validation-LIST source = N12>T12)
AF12 is the same combobox in another language ( validation-LIST source =
AN12>AT12)
The values in source1 and source2 has the same contence and possition just a
translation.

When selecting value 2 in F12 ( source O12) I want AF12 be set to value 2
( source AO12).

HOW, if it is possible ?

Thanks,

Filip

I am programming in Excel Macro with VBA, Is there anyone know how to deal
with "Select Multiple items" in page area. i.e.: In page area, there is
product dimension. In Excel 2003, PivotTable provides "Select Multiple Items"
feature in page area. I want to select more products A ,B ,C. I should use
"Select multiple items". Is there any object to provide this feature to catch
these values?
--
Developer
QA Dashboard
Microsoft China Development Centre

I have created a combo box that is populated with 8 items when the comboBox dropdown is clicked. What I want to do should be simple. When a user clicks on one of the items in the comboBox, that item needs to appear in the comboBox text box.

I've searched around and checked the MSDN library, but can't find a clear explanation.

Thanks.

When I use filters on pivot tables that others create, I can select multiple
values on which to filter. There is a little white box next to each item
that I can select by putting a check mark in it. However, when I create a
pivot table, I can only select one item from the filter at a time. How do
you set up the pivot table so you can select multiple items?

Thanks.
--
Anne

Hi,
I have a multiple names in sheet 2 column 1 (approx 12)

I want to be able to select multiple items from a drop down list in sheet 1 and populate them all in one cell, seperated by comma, or semi colon.
The drop list will also auto update if any name is later added in the sheet 2.
Please help.
Thanks and regards

I've made a database for my work using excel. Essentially the user just puts in the name of a new resource and then enters details about them from data validation drop down lists defined on another page of the worksheet. When a client comes along they can use data filtering on the list to look up all resources in a specific location or sector for example, there's several different criteria. The thing is, some resources operate in several regions and sectors and so the records are incomplete.

There's a number of ways to get around this that I know of, creating more than one record per resource for example where each variation of their details is entered. However, if for example they operate in three regions and four sectors I'll need to create twelve records just for that one resource which would get pretty time consuming. Another thought I had was that I could simply make multiple columns for each category so that you can make multiple selections that way but some of the resources could easily have upwards of five or six selections per category. All these solutions seem a bit clumsy to me though so I've been trying to come up with a way to be able to use check boxes or something similar in the drop down list. Is there any way, for example, to be able to select sectors 4, 6, 10 and 13 for example from a single drop down list and have it show up when any of them are selected as a filter on the list? I've attached an example of my prototype to try and make things clearer, hopefully it does so.

I've scoured the web and help files looking for a solution on my own but I don't know if what I'm after is really possible with Excel's functionality. Hopefully I'm wrong though, does anyone have any ideas?

Thanks in advance all.

I am trying to set up data validation lists where you can select multiple
items from the data validation dropdowns in the column and items are added to
the active cell in that same column, separated by a comma.

So I have a table in which I would like to select/copy multiple columns in a table and paste them to a new work book. I have accomplished copy and pasting a single column but I am not sure how to copy multiple columns in a table.

Here is my code thus far: My


	VB:
	
 InsertColumns() 
    Dim New_Ws As Worksheet 
    Dim ACell As Range 
    Dim CCount As Long 
    Dim ActiveCellInTable As Boolean 
    Dim CopyFormats As Variant 
    Dim oSh As Worksheet 
    Set oSh = ActiveSheet 
     
    If ActiveSheet.ProtectContents = True Then 
        MsgBox "This macro will not work when the worksheet is write-protected." 
        Exit Sub 
    End If 
     
    Set ACell = Cells(5, "A") 
    On Error Resume Next 
    ActiveCellInTable = (ACell.ListObject.Name  "") 
    On Error Goto 0 
    If ActiveCellInTable = True Then 
        With Application 
            .ScreenUpdating = False 
            .EnableEvents = False 
        End With 
         
        With oSh.ListObjects("tPARTSPROD") 
            .ListColumns(1).Range.Copy [COLOR=#ff0000][SIZE=4] 'How can I get this to select more than 1 column in the
table?[/SIZE][/COLOR]
        End With 
         
         
        Set New_Ws = Workbooks.Add(xlWBATWorksheet).Worksheets(1) 
        On Error Resume Next 
        With New_Ws.Range("A1") 
            .PasteSpecial xlPasteColumnWidths 
            .PasteSpecial xlPasteValuesAndNumberFormats 
            .Select 
            Application.CutCopyMode = False 
        End With 
        On Error Goto 0 
        Application.ScreenUpdating = True 
        Application.CommandBars.FindControl(ID:=7193).Execute 
        New_Ws.Range("A1").Select 
        ActiveCellInTable = False 
        On Error Resume Next 
        ActiveCellInTable = (New_Ws.Range("A1").ListObject.Name  "") 
        On Error Goto 0 
        Application.ScreenUpdating = False 
        If ActiveCellInTable = False Then 
            Application.Goto ACell 
            CopyFormats = MsgBox("Do you also want to copy the Formats?", _ 
            vbOKCancel + vbExclamation, "Copy to new workbook") 
            If CopyFormats = vbOK Then 
                ACell.ListObject.Range.Copy 
                 
                With New_Ws.Range("A1") 
                    .PasteSpecial xlPasteFormats 
                    Application.CutCopyMode = False 
                End With 
            End If 
        End If 
    End If 
    Application.Goto New_Ws.Range("A1") 
    With Application 
        .ScreenUpdating = True 
        .EnableEvents = True 
    End With 
     
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines


How can I select multiple "locations" from a drop down or list or checkboxes and have them link or copy across to another worksheet within the same workbook.

I am currently using checkboxes but would prefer to use a drop down that allows for multiple selections. Once they are all selected, I need to be able to display them in a list on another sheet.

Thanks.

I have a small drop down list with only 4 items. I want to be able to allow
the users to choose more than one of these items. I tried using this code
Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
Dim rngDV As Range
Dim oldVal As String
Dim newVal As String
If Target.Count > 1 Then GoTo exitHandler

On Error Resume Next
Set rngDV = Cells.SpecialCells(xlCellTypeAllValidation)
On Error GoTo exitHandler

If rngDV Is Nothing Then GoTo exitHandler

If Intersect(Target, rngDV) Is Nothing Then
'do nothing
Else
Application.EnableEvents = False
newVal = Target.Value
Application.Undo
oldVal = Target.Value
Target.Value = newVal
If Target.Column = 3 Then
If oldVal = "" Then
'do nothing
Else
If newVal = "" Then
'do nothing
Else
Target.Value = oldVal _
& ", " & newVal
End If
End If
End If
End If

exitHandler:
Application.EnableEvents = True
End Sub
that I got from this site:
(http://www.contextures.com/excelfiles.html) (scroll down to Select Mulitple
Items from a drop down list).

However, after right clicking and pasting in the code, I still don't have
the option of choosing more than one option in my drop down list. I know
nothing about code, so I'd appreciate any help that can be delivered with
that constraint!

Thanks.

I have two olap pivot tables, set up so that if one page
field is changed, the same page field on the second pivot
table is changed to match.

However, if the user chooses to enable the "select
multiple items" on the page field, and then makes a
multiple selection from the page field, then the code
collapses.

Is there anyway that I can disable the "select multiple
items" box?

How do I use one list box to let me select one item in the list and get
Excel to display names related to this item in a second list box, i.e.
choose the name of a football team from one list box and display all
the playes from that team in a second list box. I then need to select
a player to display details about that player in a separate cell.

Any help would be appreciated. Thanks. Jamie81

--
jamie81
------------------------------------------------------------------------
jamie81's Profile: http://www.excelforum.com/member.php...o&userid=18516
View this thread: http://www.excelforum.com/showthread...hreadid=375168


No luck finding an answer? You could always try Google.