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...
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...
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...
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???
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...
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...
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?
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...
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...
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.
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...
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.
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...
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...
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...
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 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.