selection box

  1. Y

    Selecting Cells in a Column Based on Rows in Another Column

    Trying to make selection dynamic such that when number of rows increases or decreases the selection also gets according to it. Below is the example. What I want is: Want to select range C4:C8 as data in Column A starting from A3 is till A8. And in Table 2: Only C3 to be selected as in Column...
  2. M

    Macro to print different Worksheets in separate printjobs based on user selection

    I have a workbook with different worksheets. As these have different orientations you can't simply select and print them, as the page orientation is the same on all of them as on the first page. Now I would like to create a macro with which I can print the selected pages (which are not always...
  3. S

    VBA drop down / radio button / function to select ....

    So, I am looking for a something simple. I need to call a macro that displays a window with some options that I will pre-define, for me to select. The selection needs to be stored in a variable which I can then use later in the macro for other purposes. The issue I am having is that I can't...
  4. L

    VBA Selection Form Combo box to get list from Pivot table

    Hi all this may not be possible, I have searched threads but can't find my exact problem. I have a pivot table with 'year' and 'name'. I want to then use a selection form for a user to pick a year and name and then the pivot table will only show that data and then go on to run another macro...
  5. J

    Import specific Data from an Excel 2013 table, based on selected criteria

    Hi all. Question 1: I have an Excel Workbook that I use to record Health Assessments for a number of different companies, listed in a separate sheet in the same workbook. For each company, I then have quite a big number of employees. These are listed in a separate Excel file (all employees of...
  6. L

    Selection box via a Macro.

    Is there a way to display a selection box of available tabs that fit certain criteria to the user? I have a workbook that has up to 12 tabs. Most of which are data tabs extracted from a database that is used to populate the "Template" tab. I want to display a list of Template tabs in this book...
  7. J

    Drop down lists

    I am trying to create a form for my office. In the form I need to create a drop down list with all of my co-works names. I am using Excel 2004 and I do not want to have a source for this list, just the list with the names. Is there a way to create this list without having to validate the cell...

Some videos you may like

This Week's Hot Topics

  • SUMPRODUCT active link formula
    Hi guys i have sumproduct formula for counting two range of number, i want count active cells of formula that linked to another sheet...
  • Block certain cells in condition met in cell A
    Hi there, trying to figure out step by step how to build macros and learn more. Now given that my other code was a mess, I figured I would...
  • IF FUNCTION FIRST, THEN WITH INDEX AND MATCH
    Hi, Below formula works well, =(INDEX('PRICE LIST'!$C$7368:$C$7679,MATCH(1,(WORKSHEET!O28='PRICE LIST'!$A$7368:$A$7679)*(WORKSHEET!P28='PRICE...
  • Match data from 3 columns to return data from the correct 4th column
    Hi there! I'm trying to have a cell auto-populate the data in a cell based on the data entered in 3 other cells. I've pasted a copy of the...
  • VLookup
    Hi everyone, I need to find the value from one sheet to another. So in Sheet A Field N5 I have a value (Spark) I want to find Spark on the Sheet...
  • Defining a range
    Private Sub Worksheet_Calculate() Dim Xrg As Range Set Xrg = Range("K1") If Not Intersect(Xrg, Range("K1")) Is Nothing Then MsgBox...

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
Top