selections

  1. L

    Insert text to particular cell using VBA

    Hi all, I am trying to create a report for our marketing department to fill in figures on an ad-hoc basis. I have this idea in my head which I hope you can help with. Basically, I would like to know how to do the following: Based on what the user selects in the blue cells (using Data...
  2. D

    only allow one list box to have a selection

    I have two listboxes, lboFY and lboCY. If the use makes a single select or multiselect on lboFY, I want to clear all selections that may have been selected in lboCY and the other way around If the use makes a single select or multiselect on lboCY, I want to clear all selections that may have...
  3. btadams

    Dashboard closes upon certain slicer selections

    Hope you are all having a great day! I have a dashboard with 6 slicers. Some combinations of slicer selections have very little data and when I make those selections, Excel simply closes down (and it doesn't have any list of recovered files when I re-open Excel.). I don't think my customers...
  4. I

    VBA run-time error "the specified value is out of range"

    So i have a listbox connected to a "button" in my sheet that allows me to check off certain selections - it works great until i protect the sheet...how do i get it to run when the sheet is protected???
  5. R

    Gather ALL Combobox Selections into a Column

    Hey All, I am COMPLETELY NEW to VBA and an attempting the "learn as I go" method. I am a chef, and am attempting to create production sheets based on menu selections. I am creating a userform (UFProductionSheet) to make the selections and enter other needed details. All menu selections are...
  6. T

    Hide/Unhide Sheets based on Multiple ActiveX Checkbox selections

    I am attempting to build a workbook with approximately 30 sheets. When the user opens the workbook, there will be a set-up sheet with two questions. Based on the selections, the workbook will begin to unhide/hide the relevant sheets keeping the others hidden. Example: 1) What Products are you...
  7. C

    Using ListBox Selections to Filter

    I've created a ListBox with multiple selections, i.e.APS2, APS3, APS4, APS5, APS6, EL1, EL2 and ELPAPP. I'd like to filter Sheet3,Column D according to the levels selected. Can anyone help with coding?
  8. C

    Macro to Select Multiple Items from Dropdown Checklist

    Hello, I recently found this (www.keithyap.com.au/select-multiple-items-list-excel) online and the GIF shows exactly what I'm looking for. However, the code posted there always generates an error saying invalid object. I renamed the UserForm and the invalid object error disappears and a...
  9. A

    How can i use the same Listbox to make selections for several cells?

    Hello I have created a Listbox which allows me to make multiple selections. I then have inserted a shape to use as a button - when clicked, this writes multiple selections from the Listbox into a single cell. I have a sheet with multiple rows and I want to go through the same process for each...
  10. S

    Linking Slicers Even if Data is Not from same source

    I'm working on a dashboard and I want to create one slicer that will change all data on the page, some links to other sources not the same page, different slicers etc. Yet, the selections are the same. How is this possible? I thought there was a macro that could be linked.
  11. S

    Conditional Formatting

    Is there a way to apply conditional formatting based on another value, as opposed to typing in a certain value (that will change based on selections)?
  12. M

    Pivot Table to Read MDX Query based on Cell

    Hi All, I have a Pivot table created with Cube connection. I have a tab where we can go and select the desired selections using slicers/dropdown/etc. Based on the selections, in one particular cell, i will create a MDX query. Is there a way that query is taken and Pivot table refreshes using...
  13. R

    Using a ListBox with ListStyleOption

    I have created a UserForm in VBA Excel that has a ListBox with the ListStyleOption selected. The MultiSelectMulti option is activated. Whenever I close the user form or workbook and then reopen, all the previous selections are gone. Is there a way to retain selections made in listbox? Thanks.
  14. M

    Can I add two "With Selections"?

    How do I make this all in 12 lines? I don't think it is possible without adding the with selections Range("A1").Select With Selection.Font .Size = 36 End With With Selection .HorizontalAlignment = xlCenter .VerticalAlignment = xlCenter End With With...
  15. C

    Is there a way to categorize information in Excel?

    I am an interior designer with a lot of workbooks for different projects, but if possible I would like to streamline them into a master spreadsheet and then be able to select and print out, for example, all the tile selections in the entire house, or also just the selections for one room. Is...
  16. J

    CONCATENATE and INDIRECT issue with return

    I am using the following formula =CONCATENATE(INDIRECT(M1&"!E12"),CHAR(10),CHAR(10),INDIRECT(M1&"!E64")) The formula is retuning the correct data, but nor formatted the way I want. I need to pull two values based on the drop down selection. While it is retuning the data selections, it is...
  17. T

    Removing a selection/choice from a listbox once the choice has been selected.

    I have a worksheet that has 8 activex listboxes. Each listbox is tied to the sames list of values (identified as a named range). The named range is a list of countries. Each country should only be selected once, therefore, I would like the selected country(ies) to not show up as a choice when...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top